Forum Discussion
Remove rows based on multiple criteria
Hello What is the syntax for Power Query to remove rows on specific criteria? I want to remove rows where (Col1 contains "something" and (Col2 is zero or null)) Thanks!
Anonymous , Filter the data based on those.
https://docs.microsoft.com/en-us/power-query/filter-values
or create column and filter that
if Text.Contains([Col1], "something") and ([Col2] =0 or [col2] = null) then 1 else 0
use filter for column , on this new column
Anonymous , Filter the data based on those.
https://docs.microsoft.com/en-us/power-query/filter-values
or create column and filter that
if Text.Contains([Col1], "something") and ([Col2] =0 or [col2] = null) then 1 else 0
use filter for column , on this new column