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.

Welcome to our Power Query blog. This week, I look at calculating age.

Welcome to our Power Query blog. This week, I look at how to reformat a table of data which is made up of sub-tables.

Welcome to our Power Query blog. This week, I look at how to add a table of data to an existing query.

Welcome to our Power Query blog. This week, I look at how to find the unique or distinct values in a list of data.