Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Ageing

15 April 2020

Welcome to our Power Query blog. This week, I look at calculating age.


Power Query: Table of Tables

8 April 2020

Welcome to our Power Query blog. This week, I look at how to reformat a table of data which is made up of sub-tables.


Power Query: Row by Row

1 April 2020

Welcome to our Power Query blog. This week, I look at how to add a table of data to an existing query.


Power Query: Unique and Distinct

25 March 2020

Welcome to our Power Query blog. This week, I look at how to find the unique or distinct values in a list of data.


Power Query: Reorganising by Numbers

18 March 2020

Welcome to our Power Query blog. This week, I look at using some numerical functions to sort out expense formatting.


Power Query: Empty

11 March 2020

Welcome to our Power Query blog. This week, I look at how to achieve the opposite of fill up / down.


Power Query: Dynamic Removals

4 March 2020

Welcome to our Power Query blog. This week, I look at how to remove columns without referencing column names.


Power Query: Next (Row) Once Again Please

26 February 2020

Welcome to our Power Query blog. This week, I look at yet another solution to my “February problem” referencing other rows.


Power Query: Next (Row) Again Please

19 February 2020

Welcome to our Power Query blog. This week, I look at another solution to last week’s problem referencing other rows.


Power Query: Next (Row) Please

12 February 2020

Welcome to our Power Query blog. This week, I look at referencing other rows.


Newsletter