Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
It works! The unwanted rows are now disapeared in the pivot chart. Thank you !!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.