Forum Discussion

CliffordAP's avatar
CliffordAP
Helper II
4 years ago
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...
Need Help
Tips and Tricks
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

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

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

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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