Using DAX SWITCH by joining 2 tables.

[Anonymous]

Below is my requirement in sql. can anyone please give that equivalent SWITCH IN DAX. Both Tables in Powerbi are having a join relationship
in the model already.

CASE WHEN TableA.customertype = 'New' AND TableB.flag = 'NO' THEN 'New Customer'
,WHEN TableA.customertype = 'Existing' AND TableB.flag = 'NO' THEN 'Existing Customer'
,WHEN TableB.flag = 'Yes' THEN 'Employee'

Many Thanks

[Anonymous · Accepted solution]

I have resolved this using RELATIVETABLE function in DAX.

[Anonymous]

Hi Denis, the Condtional column which you suggeseted only allows me to add conditions based on the current table but not from other tables.  Basically i need to write SWITCH statement joining another table. Can you please help me on that ? Thanks

[Anonymous]

Hi Denis, thanks for this. but can you please provide me with that DAX SWITCH statement for creating that condtional column ?

Many Thanks

[selimovd]

Hello @Anonymous ,

join the tables in Power Query and then add a conditional column:

In the upcoming dialogue you can do the required statements.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi