Forum Discussion

lang22's avatar
lang22
Frequent Visitor
2 years ago

Rewrite Tableau to DAX

Any help yall can provide when rewriting this Tableau Calc Column to DAX is appreciated. I have been struggling using Switch(True() and combinations of && ||   IFNULL(IF ([Column1] = 1 OR [Column2]...
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, lang22 

 

because in switch function dependencies for previous condition not relate with current condition.
and here in your case currunt condition depend on previous conditions that's why I prefer nested if condition.

switch()  use when you not need to take look previous condition means your current condition is independent of other condition.
we can also use combination of switch() and if() function .

 

i hope you cleasr about it 

lang22's avatar
lang22
Frequent Visitor
2 years ago

This did not return a value, though the equation was accepted by Power BI

  • Dangar332's avatar
    Dangar332
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    hi, lang22 

    provide some sample data with expected output