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 o...
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
parry2k's avatar
parry2k
Icon for Super User rankSuper 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
  • lundande's avatar
    lundande
    Frequent Visitor
    7 years ago

    Thanks parry2k!