Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

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.


Power Query: Not Your Type

27 November 2019

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


Power Query: Time for a List

20 November 2019

Welcome to our Power Query blog. This week, we take a look at how list() functions can take you to a whole new dimension (time).


Newsletter