Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Using DAX SWITCH by joining 2 tables.

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

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I have resolved this using RELATIVETABLE function in DAX.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I have resolved this using RELATIVETABLE function in DAX.

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago


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

    Many Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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