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]
  )