Please note javascript is required for full website functionality.


Power BI Blog: Xenagogue to Markup Lists - Part 1

11 April 2018

This week we start a new project on using Get Data with the XML format.

Power Pivot Principles: Calculated Columns

10 April 2018

Welcome back to our Power Pivot blog. Today, we consider how to create a calculated column.

A to Z of Excel Functions: The DATEVALUE Function

9 April 2018

This function converts a date that is stored as text to a serial number that Excel recognises as a date..

VBA Blogs: At Least Once in Our Lives, Let’s 'Do' It!

6 April 2018

The second reason that Do…Loop is superior is that While Wend loops check for the condition prior to running – but with Do…Loop the condition can be checked at the end...

A to Z of Excel Functions: The DATEDIF Function

6 April 2018

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DATEDIF function.

Power BI Blog: Text isn't Limiting! - Part 5

5 April 2018

Last week using the US Historical Population Estimates we created our first DAX formula. Now we have categorised our data by decade, how can we focus the view on a specific decade?

Power Query: Zipping Through a List

4 April 2018

I have been looking at List functions in M language recently, and this one reminds me of my problems with null values in lists...

Power Pivot Principles: Tables, Fields and Measures

3 April 2018

Today let’s go over the syntax between a table, a field, and a measure.

Monday Morning Mulling: March 2018

2 April 2018

On the last Friday of each month we set an Excel puzzle for you to puzzle over the weekend. On the Monday, we publish a solution..

A to Z of Excel Functions: The DATE Function

2 April 2018

This function returns the sequential serial number that represents a particular date...