Tableau Formula translated into DAX

[Chanise89]

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]

[Greg_Deckler · Accepted solution]

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

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?