title: Can we compare two tables in a Switch Case in DAX Power BI?
body: <p>Is it possible to include columns from 2 different tables in DAX Switch Function ?</p>
  <p>Both of my tables are linked by Many to Many Relationship.<br />
  I am trying to create a calculated column in Table A where I want to compare Columns from Table B, but I can't add the Table B column in the DAX Switch formula. <br />
  Any suggestions would be appreciated.</p>
  <p>Thanks &amp; Regards,<br />
  Pratik</p>
  <p>Sample <br />
  <a href="https://i.stack.imgur.com/SosU2.png" rel="nofollow noreferrer">Table B</a> <br />
  <a href="https://i.stack.imgur.com/KaEIC.png" rel="nofollow noreferrer">Table A &amp; Expected Result</a></p>