Welcome to our Power Query blog. This week I look at how to deal with dates in a variety of formats.

Welcome to our Power Query blog. This week, I look at some shortcuts to use in Power BI Transform Data.

Welcome to our Power Query blog. This week, I look at how to improve the memory used when loading my flat file query to Power BI Desktop.

Welcome to our Power Query blog. This week, I look at ways to improve the memory usage of a query involving flat files.

Welcome to our Power Query blog. This week, I look at some ways to make merges more efficient.

Welcome to our Power Query blog. This week, I look at solving a problem with a nested join and the M function Table.Buffer().

Welcome to our Power Query blog. This week, I look at a way to reorganise data in a table by merging with itself.

Welcome to our Power Query blog. This week, I look at a more efficient way of merging the data from last week, again when there is not a clear link between the tables

I have some sales contact data for my imaginary business. Unfortunately, I have some complaints and I want to allocate them to the correct salesperson.

Welcome to our Power Query blog. This week, I look at the Excel.Workbook() M function