Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Rental Wrangles

28 July 2021

Welcome to our Power Query blog. This week, I look at how to expand data to create a useful table.


Power Query: Tidier Totals by Type

21 July 2021

Welcome to our Power Query blog. This week, I take another look at selective running totals.


Power Query: Totals by Type

14 July 2021

Welcome to our Power Query blog. This week I look at selective running totals.


Power Query: Faulty Filtering

7 July 2021

Welcome to our Power Query blog. This week, I look at an issue with filtering.


Power Query: A List of Distinct Possibilities

30 June 2021

Welcome to our Power Query blog. This week, I look at List.Distinct().


Power Query: Evaluate the Environment

23 June 2021

Welcome to our Power Query blog. This week I look at the importance of environment to Expression.Evaluate().


Power Query: Fixed Expression

16 June 2021

Welcome to our Power Query blog. This week, I look at the M function Expression.Constant().


Power Query: Three Sheets to the Table

9 June 2021

Welcome to our Power Query blog. This week, I look at combining sheets where the columns do not match.


Power Query: Evasive Errors

2 June 2021

Welcome to our Power Query blog. This week, I look at a problem I came across when uploading a large dataset from Excel.


Power Query: Intelligent Folding

26 May 2021

Welcome to our Power Query blog. This week, I look at how Power BI Desktop uses query folding in the Power Query engine.


Newsletter