Danny Quelch

Reduce rows & cols GOOD PRACTICE in Power Query




When you first use Power Query, you will think the Remove columns & Remove rows are the logical steps, but these are dangerous, as they don’t respond well dynamically. There are other features that work better for a number of reasons.

I walk you which attributes of Power Query transformations are bad and which ways you can remove columns & rows more sustainably less likely to break in an error proofed way.

Leave a Reply

Your email address will not be published. Required fields are marked *