Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: All Over Running Totals

10 February 2021

Welcome to our Power Query blog. This week, I return to the running totals example from last week, to apply a more complex solution.


Power Query: Keep on Running

3 February 2021

Welcome to our Power Query blog. This week, I revisit running totals.


Power Query: Part Time

27 January 2021

Welcome to our Power Query blog. This week, I look at adding rows to existing data in order to present a complete picture.


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.


Newsletter