Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Thanks for the Memory

2 May 2018

This week, I look at what to do if you are short of memory.


Power Query: Hot Cross Joins

25 April 2018

This week I look at cross joins.


Power Query: Join Me at the Table

18 April 2018

Whilst there are often multiple ways to achieve the same objective in Power Query, the purpose of today’s example is become familiar with the M function, Table.Join.


Power Query: Comparing Lists

11 April 2018

Welcome to our Power Query blog. This week, I look at how to use the List function to compare lists.


Power Query: Zipping Through a List

4 April 2018

I have been looking at List functions in M language recently, and this one reminds me of my problems with null values in lists...


Power Query: Seeded Accommodating Accumulating

28 March 2018

This week, I look at the M function List.Accumulate and its uses where the seed is not zero.


Power Query: Seedless Accommodating Accumulating

21 March 2018

This week, I look at simple examples of how to use the M function List.Accumulate...


Power Query: Moving Date

14 March 2018

This week, I look at how to transform extracted data into a useful table.


Power Query: Sorry, Not on the List

7 March 2018

This week, I take a look at how extracting data from multiple lists can be confusing when nulls are involved.


Power Query: Passing (Reference to) Excel Parameters

28 February 2018

Welcome to our Power Query blog. This week, I take a look at how to pass Excel data as a parameter in Power Query.


Newsletter