Forum Discussion

Chanise89's avatar
Chanise89
Icon for Helper I rankHelper I
3 years ago
Solved

Translate this Tableau calculation into a DAX Expression

Hi all,

 

I am having trouble translating this calcualted formula into a DAX expression: 

 

Account Group =
if CONTAINS([Acc Level 1 Des],"Comp") then "Compensation"
//ELSEIF CONTAINS([Acc Level 2 Des],"Headcount") then "Compensation"
ELSEIF CONTAINS([Acc Level 3 Des],"Null 2") then "Null 2"
ELSEIF CONTAINS([Acc Level 1 Des],"Var") then "Variable"
ELSEIF CONTAINS([Acc Level 1 Des],"Oper") then "Operating"
else [Operating Levels (group)] END

 

Any help would be greatly appreciated.

Thank You!

2 Replies