Please note javascript is required for full website functionality.



Power BI Tips: Xenagogue to Markup Lists - Part 1

12 April 2018

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

Power Query: Comparing Lists

11 April 2018


Welcome to our Power Query blog. This week, I look at how to use the List function to compare lists.

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..

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.

VBA Blog: 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...

Power BI Tips: 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.

A to Z of Excel Functions: The DATE Function

2 April 2018

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