Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Value Added

13 March 2019

Welcome to our Power Query blog. This week, I look at the Value.Is() M functionality.


Power Query: Find the Folder

6 March 2019

Welcome to our Power Query blog. This week, I look at an example which uses some of the M functionality for dealing with files and folders.


Power Query: Fold(er) Away

27 February 2019

Welcome to our Power Query blog. This week, I look at some of the M functionality for dealing with folders.


Power Query: File Away

20 February 2019

Welcome to our Power Query blog. This week I look at some of the M functionality for dealing with files.


Power Query: Zoned Out

13 February 2019

Welcome to our Power Query blog. Last week’s blog looked at solving a particular problem by using DateTime.AddZone(). This week, I look at some of the M functionality for dealing with time zones.


Power Query: In the Zone

6 February 2019

Welcome to our Power Query blog. This week, I look at some issues when dealing with extracted dates.


Power Query: Conditional Column Splitting

30 January 2019

Welcome to our Power Query blog. This week, I look at an example where one column contains both header and detail data.


Power Query: Select a Number

23 January 2019

Welcome to our Power Query blog. This week, I look at extracting a number from a mixed column.


Power Query: A Join I Made Earlier

16 January 2019

Welcome to our Power Query blog. This week, I look at a neat way of linking tables with similar key data.


Power Query: Skipping Lists

9 January 2019

Welcome to our Power Query blog. This week I look at M functions List.Skip() and List.Alternate().


Newsletter