Welcome to our Power Query blog. This week, I look at (some of the most) simple M statements.

Welcome to our Power Query blog. This week, I look at how to deal with imported errors.

Welcome to our Power Query blog. This week, I take a look at some tips to help get the best out of Power Query.

Welcome to our Power Query blog. This week, I consider how to upload data from a relational database.

Welcome to our Power Query blog. July brought some improvements to Power Query/Get and Transform. I look at how creating a column from examples has developed.

Welcome to our Power Query blog. Last week’s blog looked at how to use list functionality to translate numerical grades into their letter equivalents. This week, I use another List() function to look for multiple keywords in columns of data.

Welcome to our Power Query blog. This week, I take a final look at an example where I need to translate numbers to letters in multiple columns, this time using the M function List.ReplaceMatchingItems() and matching those items using values from another table.

Welcome to our Power Query blog. This week, I look at last week’s problem again, but this time I translate numbers to letters in multiple columns by joining tables.

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.