Welcome to our Power Query blog. This week I look at how to customise function descriptions by using M function meta-data.

Power Query and Power Pivot work well together, however Power Query is not exclusive to Power Pivot though, as it may be used with ordinary PivotTables. There is a good reason for doing this too...

This week I look at combining several Power Query functions in order to standardise some incoming data...

The scenario is familiar, a huge Excel table comes in with lots of columns and rows, but in some cases a column or row is empty and it needs to be condensed...

A huge Excel table comes in with lots of columns and rows, but in some cases a column or row is completely empty, and the table needs to be condensed...

Sometimes, I am happily working away in Power Query when I hit a problem. Features are not there when I need them, something I’m sure should have worked doesn’t...

Since I have reached the milestone of my 50th issue, I have covered a whole list of Power Query features. Talking of lists… (it’s an ellipsis, get it?)

This week I look at bringing in two tables of data and summarising some of that data. At the same time..

It’s time to move on...

Welcome to our Power Query blog. This week I look at the options available to organise queries within a workbook.