Trying to rewrite the following IFELSE satement in DAX

[Lolu]

Hi Guys,

I am trying to reqritethis in DAX.

(IF [CASEPRIORITY] = 1 THEN [CRITICALRESPONSETIME]

ELSEIF [CASEPRIORITY] = 2 THEN [URGENTRESPONSETIME]

ELSEIF [CASEPRIORITY] = 3 THEN [NORMALRESPONSETIME]

END)

At the moemnt I am only able to write for one condition, how can I get all three in one DAX statement.

Many Thanks in Advance.

L

[TomMartens · Accepted solution]

Hey,

I guess you are looking for the SWITCH() function:

https://msdn.microsoft.com/en-us/library/gg492166.aspx

Hope this helps

[Lolu]

Yes! I rewrote it as

Deadline = SWITCH([CASEPRIORITY],"1",[CRITICALRESPONSETIME],"2",[URGENTRESPONSETIME],"3",[NORMALRESPONSETIME])

and it works prectectly.

Thanks

L

[v-ljerr-msft]

Hi @TomMartens,

Great to hear the problem got resolved! Could you accept the helpful reply as solution to close this thread? 

Regards