Forum Discussion

lundande's avatar
lundande
Frequent Visitor
7 years ago
Solved

M Power Query: Removing entire rows based on true/false

i'm new to powerBi and having issues trying to remove specfic rows. I am trying to remove all the rows where Amount and Amount2 don't match. I'm sure there is a simple formula but I can't figure it out...

 

 

 

 

Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    lundande you can add new custom column to compare and then filter on it. In custom column add following expression and then filter on this new custom column where value = 0

     

    if [Amount]=[Amount2] then 1 else 0

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    lundande you can add new custom column to compare and then filter on it. In custom column add following expression and then filter on this new custom column where value = 0

     

    if [Amount]=[Amount2] then 1 else 0