Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Dynamic Merging

6 May 2020

Welcome to our Power Query blog. This week, I look at working dynamically with merged queries.


Power Query: Folders Only

29 April 2020

Welcome to our Power Query blog. This week, I look at extracting a list of folders.


Power Query: Big Comparison

23 April 2020

Welcome to our Power Query blog. This week, I look at comparing data in two large CSV files.


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.


Newsletter