Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Next (Row) Once Again Please

26 February 2020

Welcome to our Power Query blog. This week, I look at yet another solution to my “February problem” referencing other rows.


Power Query: Next (Row) Again Please

19 February 2020

Welcome to our Power Query blog. This week, I look at another solution to last week’s problem referencing other rows.


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.


Newsletter