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]...
JamesFR06's avatar
JamesFR06
Icon for Resolver IV rankResolver IV
2 years ago

HI

IF(
ISBLANK(
IF(
OR([Column1] = 1, [Column2] = 1),
AND(
OR([Column3] = 1, [Column4] = 1, [Column5] = 1, [Column6] = 1, [Column7] = 1),
[Column8] = 0
),
""
)
),
IF(
ISBLANK(
IF(
OR([Column1] = 1, [Column2] = 1),
AND(
[Column3] = 0,
[Column4] = 0,
[Column5] = 0,
[Column6] = 0,
[Column7] = 0,
[Column8] = 0
),
""
)
),
IF(
ISBLANK(
IF(
OR([Column1] = 0, [Column2] = 0),
AND(
OR([Column3] = 1, [Column4] = 1, [Column5] = 1, [Column6] = 1, [Column7] = 1),
[Column8] = 0
),
""
)
),
IF([Column8] = 1, "NIAN", "NIAN"),
"C Only"
),
"A Only"
),
"A&C"
)

 

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

  • lang22's avatar
    lang22
    Frequent Visitor
    2 years ago
    AvC =
     
    RETURN
        SWITCH (
            TRUE (),
            (C1 = "1" || C2 = "1") &&
                (
                    C3= "1" ||
                    C4 = "1" ||
                    C5 = "1" ||
                    C6 = "1" 
                 ) && C7 = "0",
            "AC",
            (C1 = "1" || C2 = "1") &&
                (
                    C3 = "0" &&
                    C4 = "0" &&
                    C5 = "0" &&
                    C6 = "0"
                ) && C7 = "0",
            "A Only",
            (C1 = "0" || C2 = "0") &&
                (
                    C3 = "1" ||
                    C4 = "1" ||
                    C5 = "1" ||
                    C6 = "1"             
                ) && C7 = "0",
            "C Only",
            C7 = "1",
            "Nian",
            "Nian"
        )