Welcome to our Power Query blog. This week, I look at how text output can be presented.

Welcome to our Power Query blog. This week, I look at how to fill in rows when there is a gap in dates.

Welcome to our Power Query blog. This week, I look at how to calculate a group share.

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.