Forum Discussion
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]...
Why is Switch and True not something you are using? It's not a requirement ovbiously, just curious
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"
)