cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
lundande Frequent Visitor
Frequent Visitor

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...

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

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

@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




Did I answer your question? Mark my post as a solution!


Proud to be a Datanaut! Connect with me on Linkedin.
Feel free to email me with any of your BI needs.




 




2 REPLIES 2
Super User
Super User

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

@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




Did I answer your question? Mark my post as a solution!


Proud to be a Datanaut! Connect with me on Linkedin.
Feel free to email me with any of your BI needs.




 




lundande Frequent Visitor
Frequent Visitor

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

Thanks parry2k!