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

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

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

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

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

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?

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

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

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

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