Welcome to our Power Query blog. This week, I look at a more efficient method to spot overlapping periods.

Welcome to our Power Query blog. This week, I look at a method to spot overlapping periods.

Welcome to our Power Query blog. This week, I look at a method to make column transformations more dynamic.

Welcome to our Power Query blog. Today, I am looking at two ways to reference a previous value in a column.

Welcome to our Power Query blog. This week, I continue my look at some new additions to the View tab, which are still not available on all versions of Power Query. Today, I look at ‘Column Profile’ and ‘Column Quality’.

Welcome to our Power Query blog. This week, I take a look at some new additions to the view tab, which are still not available on all versions of Power Query. I begin with Column Distribution.

Welcome to our Power Query blog. This week, I look at splitting my data into the top two (for example) and the rest.

Welcome to our Power Query blog. This week, I look at working dynamically with merged queries.

Welcome to our Power Query blog. This week, I look at extracting a list of folders.

Welcome to our Power Query blog. This week, I look at comparing data in two large CSV files.