Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Next (Row) Please

12 February 2020

Welcome to our Power Query blog. This week, I look at referencing other rows.


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.


Newsletter