Forum Discussion

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

Tableau Formula translated into DAX

HI all,   I have been trying to translate this Tableau formula into a DAX expression but it keeps failing.    Can someone help?   if CONTAINS( [Acc Level 1 Des],"Oper") and CONTAINS([Acc Level ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Chanise89 Try:

    Column = 
  SWITCH(TRUE(),
    FIND("Oper",[Acc Level 1 Des],,-1) > -1 && FIND("Misc",[Acc Level 2 Des],,-1)>-1, [Acc Level 3 Des],
    FIND("Oper",[Acc Level 1 Des],,-1) > -1 && FIND("Head",[Acc Level 2 Des],,-1)>-1, [Acc Level 3 Des],
    FIND("E7421",[Acc Level 3],,-1) > -1, [Acc Level 3 Des]
  )
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Chanise89 Try:

Column = 
  SWITCH(TRUE(),
    FIND("Oper",[Acc Level 1 Des],,-1) > -1 && FIND("Misc",[Acc Level 2 Des],,-1)>-1, [Acc Level 3 Des],
    FIND("Oper",[Acc Level 1 Des],,-1) > -1 && FIND("Head",[Acc Level 2 Des],,-1)>-1, [Acc Level 3 Des],
    FIND("E7421",[Acc Level 3],,-1) > -1, [Acc Level 3 Des]
  )
Chanise89's avatar
Chanise89
Icon for Helper I rankHelper I
3 years ago

Thank you Greg. Sorry I left off some of the formula... Here is the entire thing:

 

if CONTAINS( [Acc Level 1 Des],"Oper") and CONTAINS([Acc Level 2 Des],"Misc") then [Acc Level 3 Des]

ELSEIF CONTAINS( [Acc Level 1 Des],"Oper") and CONTAINS([Acc Level 2 Des],"Head") then [Acc Level 3 Des]

ELSEIF CONTAINS([Acc Level 3],"E7421") then [Acc Level 3 Des]
else [Acc Level 2 Des]
END

 

It would essentially be the same right?