conditional column: if [field] in (“a”,”b”,”c”) then x else y

[ghdunn]

I am adding a conditional column to a data table and find that If [field] = “a” then 1 else If [field] = “b” then 2 else..... etc etc ...works fine. However... I would like to use an ‘in’ condition like MS Access If [field] IN (“a”,”b”,”c”) then 3 else.... Looked extensively on web but nothing seems to deal with this. Thanks

[LivioLanzo · Accepted solution]

Hello @ghdunn

you can use the List.Contains function: https://docs.microsoft.com/en-us/powerquery-m/list-contains

if List.Contains({"a","b","c"}, [field1]) then "it contains it" else "it does not contain it"

[ghdunn]

Thanks..I did look at ListContains but just didn't twig that the syntax would work like that...was so convinced that there would be some 'IN' condition hidden in 'M' 🙂  My bad.   Thanks for super quick response.