Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Keeping it Current – Part 2

13 July 2022

Welcome to our Power Query blog. This week, I start to convert the query to look for data in the current workbook.


Power Query: Keeping it Current – Part 1

6 July 2022

Welcome to our Power Query blog. This week, I copy a query to the workbook data has been extracted from.


Power Query: See it, Save it, Sort it - Part 7

29 June 2022

Welcome to our Power Query blog. This week, I refine my grouping and show how to preserve data order while grouping.


Power Query: See it, Save it, Sort it - Part 6

22 June 2022

Welcome to our Power Query blog. This week, I group my data.


Power Query: See it, Save it, Sort it - Part 5

15 June 2022

Welcome to our Power Query blog. This week, I amend my merge to filter my data.


Power Query: See it, Save it, Sort it - Part 4

8 June 2022

Welcome to our Power Query blog. This week, I reorganise the data from my appended queries.


Power Query: See it, Save it, Sort it - Part 3

1 June 2022

Welcome to our Power Query blog. This week, I append queries to extend my data.


Power Query: See it, Save it, Sort it - Part 2

25 May 2022

Welcome to our Power Query blog. This week, I continue looking at a sorting issue.


Power Query: See it, Save it, Sort it - Part 1

18 May 2022

Welcome to our Power Query blog. This week, I begin looking at a sorting issue, by initially considering Best Practice when extracting my data.


Power Query: More Haste Less Steps Part 4

11 May 2022

Welcome to our Power Query blog. This week, I look at how to move steps.


Newsletter