Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Overfill

5 February 2020

Welcome to our Power Query blog. This week, I look at filling issues.


Power Query: Sort it Out

29 January 2020

Welcome to our Power Query blog. This week, I look at sorting issues.


Power Query: Reconcilable Differences

22 January 2020

Welcome to our Power Query blog. This week, I look at a common problem in Finance – performing that pesky bank reconciliation!


Power Query: Group Functions

15 January 2020

Welcome to our Power Query blog. This week, I look at using some M functions on grouped data.


Power Query: Solid Summary

8 January 2020

Welcome to our Power Query blog. This week, I look at a use for grouping.


Power Query: Common Merging

1 January 2020

Welcome to our Power Query blog. This week, I look at a common problem.


Power Query: Even More Fun with (Un)Pivot

25 December 2019

Welcome to our Power Query blog. This week, I look at another example of unpivoting.


Power Query: More Fun with (Un)Pivot

18 December 2019

Welcome to our Power Query blog. This week, I look at another use for unpivoting.


Power Query: Fun with (Un)PivotTable

11 December 2019

Welcome to our Power Query blog. This week, I look at a use for unpivoting.


Power Query: The Wrong Type

4 December 2019

Welcome to our Power Query blog. This week, I look at a problem when assigning data types to columns.


Newsletter