Latest Enterprise DNA Initiatives

M filter row where column in ("a","b")

I have a need to filter the import where the columns are not one of three values.
So [Currency] cannot be GB or Euro or Yen

Currently I have three rows of m that do
Table.SelectRows(#… , each [Currency] <> “GB”
Table.SelectRows(#… , each [Currency] <> “Euro”
Table.SelectRows(#… , each [Currency] <> “Yen”

is it possible to do a in and a list like SQL has
in (“GB”,“Euro”,YEN")

Thanks
E

Hi @ells

You can write only in one line like below

=Table.SelectRows(#“Removed Duplicates”, each ([Currency] <> “GB” and [Currecy] <> “Euro” and [Currency] <> “Yen” ))

1 Like

Try This

= Table.SelectRows(#“Removed Duplicates”, each List.Contains({“GB”,“Euro”,“Yen”},[Currency])=false)

1 Like

Thanks,
just trying that now.
E

I hate that m is case sensitive. Works a treat

Thanks
E