Power Query Blogs

Power Query: Absolutely Fabulous

1 May 2019

Welcome to our Power Query blog. Today, I am going to look at how Power Query turns a tricky transformation into a simple task.

24 April 2019

Welcome to our Power Query blog. Today, I am going to look at how to protect specific data when transforming text case.

17 April 2019

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

10 April 2019

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

3 April 2019

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

27 March 2019

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

20 March 2019

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

13 March 2019

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

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.

27 February 2019

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