Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Rental Wrangles Receipts - Part 2

18 August 2021

Welcome to our Power Query blog. This week, I continue with my example where I need to transform my data after I applied a function.


Power Query: Rental Wrangles Receipts - Part 1

11 August 2021

Welcome to our Power Query blog. This week, I look at an example where I need to transform my data before I can apply a function.


Power Query: Refined Rental Wrangles

4 August 2021

Welcome to our Power Query blog. This week, I look at creating a function to get data from a table.


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().


Newsletter