title: Powerquery IN operator in conditional column
body: <p>How this m Power BI M code can be modified </p>
  
  <pre><code>= 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"])
  </code></pre>
  
  <p>into a one line code similar to SQL </p>
  
  <pre><code>case when [Column1] in ("value1", "value2", "value3") then "bingo" else "Some other value" end
  </code></pre>
  
  <p>I would not like to repeat the lines <code>else if</code> but have it in a similar way as </p>
  
  <pre><code>List.Contains({'Value1', 'Value2', 'Value3'}, [Column1])
  </code></pre>
  
  <p>used here: <a href="https://stackoverflow.com/a/51749519/1903793">https://stackoverflow.com/a/51749519/1903793</a></p>