PowerQuery removing columns based on total value of a condition

[ruthhacche]

I have a nominal transaction listing. I want to remove those rows where they sum to nil based on criteria (I am trying to get rid of all those pesky data cleansing journals)

So IF Source is 3 AND narrative is identical THEN sum the value - and I shall remove all the zeroes. But I do not want to group as this is just a cleansing step not generating my output and I do not want to lose all the other data in this table. Any suggestions?

 

[ruthhacche]

Its OK sandy Thanks for all your help. I am going to do this in SQL. have a good day.

 

[sandy666]

You are welcome