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.

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.