Forum Discussion
Solved
Remove row when columns match?
Is there a way to remove rows based on number or date matching between two columns? In this case I need to be able to remove a row only when column B (Checkout) and column C (Master Date) have the sa...
Yep and much easier ( i think ) since can leverage Power Query. Take a look at the attached PBIX file, go to Power Query and look at the applied steps on the right hand side. You can see each step as it happens
PBIX file:
Yep and much easier ( i think ) since can leverage Power Query. Take a look at the attached PBIX file, go to Power Query and look at the applied steps on the right hand side. You can see each step as it happens
PBIX file:
Thanks for the help that worked like a charm!
Hi! I would like to remove the row instead of using the filter of 0 and 1. Any suggestion?
