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

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

2 Replies

  • 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?