Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: All Dates Must Change

2 December 2020

Welcome to our Power Query blog. This week, I look at how to dynamically set the Data Type on all my datetime columns to date.


Power Query: Space for a CamelCase

25 November 2020

Welcome to our Power Query blog. This week, I look at how to automate inserting spaces into CamelCase headings.


Power Query: Recent Dates

18 November 2020

Welcome to our Power Query blog. This week, I show how to only extract the dataset for the last two years, say.


Power Query: More Searching Questions

11 November 2020

Welcome to our Power Query blog. This week, I answer some (even) more searching questions.


Power Query: Searching Questions

4 November 2020

Welcome to our Power Query blog. This week, I answer some searching questions.


Power Query: Expand Your Calendar

28 October 2020

Welcome to our Power Query blog. This week, I finish my calendar creation.


Power Query: Update Your Calendar

21 October 2020

Welcome to our Power Query blog. This week, I look at calendar creation.


Power Query: To Do List

14 October 2020

Welcome to our Power Query blog. This week, I check the list(s).


Power Query: Going for the Record

7 October 2020

Welcome to our Power Query blog. This week, I put the spotlight on records.


Power Query: Almost There

30 September 2020

Welcome to our Power Query blog. We turn 200!! To celebrate, I do nothing other than write another article! This week, I look at how to add a fuzzy column.


Newsletter