Welcome to our Power Query blog. This week, I look at an example of how to work with maximum values.

Welcome to our Power Query blog. This week, I look at a quick method to set column types.

Welcome to our Power Query blog. This week I look at a method to conditionally replace values efficiently.

Welcome to our Power Query blog. This week, I look at using the ‘if’ statement.

Welcome to our Power Query blog. This week, I look at replacing values in all columns in a table.

Welcome to our Power Query blog. This week, I look at transposing versus unpivoting data.

Welcome to our Power Query blog. This week. I look at data from a sheet made up of a number of tables, with a random amount of data that needs to be excluded.

Welcome to our Power Query blog. This week, I again look at the fill down problem I have considered for the past two weeks this time using a column copy solution.

Welcome to our Power Query blog. This week, I look at a more efficient method to solve last week’s fill down problem.

Welcome to our Power Query blog. This week, I look at an example where using the standard fill down will not work and I have to use a conditional column to fill down instead.