Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Binary Function

20 January 2021

Welcome to our Power Query blog. This week, I look at using a function when processing binary data.


Power Query: Pivot Problems

13 January 2021

Welcome to our Power Query blog. This week, I look at an example using a pivot.


Power Query: New Year Function

6 January 2021

Welcome to our Power Query blog. This week, I look at an example using custom functions.


Power Query: Timings

30 December 2020

Welcome to our Power Query blog. This week, I look at an example where I need to sum time.


Power Query: Options for Table Groups

23 December 2020

Welcome to our Power Query blog. This week, I look closer at Table.Group(), which I used last week.


Power Query: Divided Groups

16 December 2020

Welcome to our Power Query blog. This week, I look at how to group into changes of value.


Power Query: I Gather That’s Right

9 December 2020

Welcome to our Power Query blog. This week, I look at how to gather data from multiple rows.


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.


Newsletter