Forum Discussion
Solved
PowerQuery - Remove rows that have matching values between 2 columns
Hey guys, I have a small ask about removing rows. I simply want to remove the rows that match. I tried M queries like: = Table.RemoveMatchingRows(#"CostomStep",[Column1=Column2]) But I'm not sure...
Simply do the reverse i.e. SelectRows rather than Removing Rows which is easier to write
= Table.SelectRows(#"CostomStep", each [Column1]<>[Column2])
Simply do the reverse i.e. SelectRows rather than Removing Rows which is easier to write
= Table.SelectRows(#"CostomStep", each [Column1]<>[Column2])
That's what I'm talkin about! Thank you!
