Filter out 0

[Kishore_C]

In Powerquery editor I need to remove '0' from Column W, Which can be done with simple filter out '0' option, BUT the issue is this process is removing other rows which has data, In the attached excel I have data, where column M, O, Q, S,U and W are my major criteria. If I filter out 0 from W, the values in these other columns as well removed.
My requirement would be, even if column W has filter out 0, it should check column M,O,Q,S and U if any values are there and retain the rows and show 0 in column W.

 

[Debaser]

You could add a custom column with a formula like:

List.AllTrue({[Invoice Balance2]=0, [Debit Memo Balance]=0,[Credit Balance]=0,[#"Unapplied Payment "]=0,[#"On-a/c Credit Memo "]=0,[Account Bal3]=0})

then filter that column for False.

 

[Chihiro]

If I understood it right...
You just need OR condition.
Filter any column, in the menu go to Advanced. Add all the columns and set it to >0 and OR for all column.

 

[p45cal]

Taking @Debaser 's idea a bit further by not having a new column step, with the likes of:

= Table.SelectRows(Source, each not (List.AllTrue({[Invoice Balance2]=0,[Debit Memo Balance]=0,[Credit Balance]=0,[#"Unapplied Payment "]=0,[#"On-a/c Credit Memo "]=0,[#"Account Bal3"]=0})))

where Source is your previous step.