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.

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

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

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.

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.

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

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.

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

Welcome to our Power Query blog. This week, I look at a more comprehensive method to convert a check box into a name.

This week, I look at a simple method to convert a check box into a name (next time I will move up a gear!).