Please note javascript is required for full website functionality.

Power Query Blogs

Power Query Blogs

Power Query: Technically Dating

25 July 2018

Welcome to our Power Query blog. This week, I look at some useful logical M functions to convert data into dates or vice versa.


Power Query: Currently Dating?

18 July 2018

Welcome to our Power Query blog. This week, I look at some useful logical M functions to determine whether a date is in a particular period.


Power Query: End of Dates

11 July 2018

Welcome to our Power Query blog. This week, I look at some ways to determine the end (and the start) of a particular date period in M.


Power Query: Getting Something Out of a Date

4 July 2018

Welcome to our Power Query blog. This week, I look at some useful ways to extract data from dates in M.


Power Query: Changing Dates

27 June 2018

Welcome to our Power Query blog. This week I look at some useful ways to manipulate dates in M.


Power Query: Sub Texting

20 June 2018

Welcome to our Power Query blog. Following on from last week’s blog, this week I look at some useful extraction Text() functions in M.


Power Query: Tidy Texting

13 June 2018

Welcome to our Power Query blog. Following on from last week’s blog, this time I look at some useful transforming Text() functions in M.


Power Query: True Texting

6 June 2018

Welcome to our Power Query blog. This week, I look at some useful Boolean Text() functions in M.


Power Query: Candid Columns

30 May 2018

Welcome to our Power Query blog. This week, I look at an example where data comes in one Excel column and needs to be converted to a table.


Power Query: Splendid Splitting

23 May 2018

Welcome to our Power Query blog. This week, I look at splitting data using a variety of delimiters.


Newsletter