Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Files for Today

17 April 2019

Welcome to our Power Query blog. Today, I am going to select files using the date embedded in the file name.


Power Query: Interactive Query

10 April 2019

Welcome to our Power Query blog. This week, I look at how to make a functional query more interactive.


Power Query: Functional Query

3 April 2019

Welcome to our Power Query blog. This week, I look at how to make a query more functional.


Power Query: Types of Value

27 March 2019

Welcome to our Power Query blog. This week, I introduce more Value() M functions; Value.Type() and Value.ReplaceType().


Power Query: Extra Value

20 March 2019

Welcome to our Power Query blog. This week, I look at some more Value M functionality.


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.


Newsletter