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

Power Query
1

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

2

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
3

Try This

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

1 Like
4

Thanks,
just trying that now.
E

5

I hate that m is case sensitive. Works a treat

Thanks
E