title: Switch (True); The same column contain multiple search criteria in Power BI
body: <ol>
  <li>If column A contain &quot;TP&quot; then &quot;Yes&quot;.</li>
  <li>If column A contain &quot;TP-&quot; then &quot;Yes&quot;.</li>
  <li>If column A contain &quot;-A&quot; then &quot;Yes&quot;.</li>
  <li>If column A does not contain &quot;TP&quot;,&quot;TP-&quot;,&quot;-A&quot; then desired result is &quot;No&quot;.</li>
  </ol>
  <p>In Excel I am applying the following formula in order to get the my final result.</p>
  <pre><code>=IF(SUM(COUNTIF(A2,{&quot;*TP&quot;,&quot;*TP-*&quot;,&quot;*-A*&quot;})),&quot;YES&quot;,&quot;NO&quot;)
  </code></pre>
  <p><strong>Note:</strong></p>
  <p>Column A contain text and numbers and Prefix and suffix or prefix with suffix as well.</p>
  <p>DATA and DESIRED RESULT;</p>
  <pre><code>ITEM        DESIRED RESULT
  1234567TP           YES
  1234567TP-0001      YES
  1234567TP-0001DR    YES
  1234567TP-DR0001DR  YES
  1234567TP-A0006DR   YES
  1234567TP-A90001DR  YES
  1234567TP-A0001DR   YES
  7674859YO-A891      YES
  456YO-A12           YES
  87654HI-A0000098    YES
  1234678VU           NO
  1234678VU-P00094    NO
  1234678VU-P00089    NO
  1234678VU-P00567    NO
  </code></pre>
  <p><a href="https://i.stack.imgur.com/14OMw.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/14OMw.png" alt="enter image description here" /></a></p>