Forum Discussion
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 = 'Ne...
I have resolved this using RELATIVETABLE function in DAX.
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