Welcome to our Power Query blog. This week, I look at an example where I need to translate numbers to letters in multiple columns using the M function List.ReplaceMatchingItems().

Welcome to our Power Query blog. This week, I look at an example where I need to calculate the stock needed from a supplier.

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

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.

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.