table.removeMatchingrows not working

[Watson]

Hi all,

intent to remove rows based on columns value.

Already added a conditional columns "toberemove", where if previous column didn't meet the criteria, a "0" will show here.

then apply

Table.RemoveMatchingRows(#"Reordered Columns",{[toberemove = 0]})

It's not removing any rows containing 0.

where is my mistake?

thanks

Watson

[ppm1 · Accepted solution]

Note you could just filter to where your column <> 0, but try this syntax instead. You need to put the full row (values for all fields) in the list to get it to work w/o the 3rd parameter (or you can just add the specific field to look at like this).

Table.RemoveMatchingRows(#"Reordered Columns",{[toberemove = 0]}, "toberemove")

Pat

[Watson]

It works! The unwanted rows are now disapeared in the pivot chart. Thank you !!