Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Obstructed View

8 September 2021

Welcome to our Power Query blog. This week, I look at some errors that can be encountered using Table.View().


Power Query: Fruit Frustration – Part 2

1 September 2021

Welcome to our Power Query blog. This week, I explain the problems when changing steps.


Power Query: Fruit Frustration – Part 1

25 August 2021

Welcome to our Power Query blog. This week, I look at how changing steps can lose data.


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.


Newsletter