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 I'm filling in the arguments correctly, and the documentation is pretty bad for beginners to figure out.
| Column1 | Column2 |
| A | B |
| C | D |
| E | E |
| F | G |
| H | H |
Just need to remove the rows that have matching values between these columns.
Thank you!
Simply do the reverse i.e. SelectRows rather than Removing Rows which is easier to write
= Table.SelectRows(#"CostomStep", each [Column1]<>[Column2])
3 Replies
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!
