PowerQuery - Remove rows that have matching values between 2 columns

[CliffordAP]

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!

[Vijay_A_Verma · Accepted solution]

Simply do the reverse i.e. SelectRows rather than Removing Rows which is easier to write

= Table.SelectRows(#"CostomStep", each [Column1]<>[Column2])

[CliffordAP]

That's what I'm talkin about! Thank you!

[Anonymous]

I would make a custom column with

each if[Column1] = [Column2] then "True" else "False")

Then filter out the "True" values in the custom column.

--Nate