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]...
lang22's avatar
lang22
Frequent Visitor
2 years ago

Why is Switch and True not something you are using? It's not a requirement ovbiously, just curious

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