Powerquery IN operator in conditional column

Question

Is there any way to modifie the code below

= Table.AddColumn(#"PreviousStep", "Tag", each 
     if Text.Contains([Column1]) = "value1" then "bingo" 
else if Text.Contains([Column1]) = "value2" then "bingo"
else if Text.Contains([Column1]) = "value3" then "bingo"
else ["Some other value"])

into code similar to SQL

case when [Column1] in ("value1", "value2", "value3") then "bingo" else "Some other value" end 

How can I do that? 

Answer 1

Use the following measure:

= Table.AddColumn(#"PreviousStep", "Tag", each if List.AnyTrue(List.Transform({"value1", "value2", "value3"}, (s) => Text.Contains([Column1], (s)))) then "bingo" else "Some other value")

Want to learn more about Power Bi, Refer & learn Power bi

Also, check out our YouTube video to know the data visualization basics and best practices with Power BI