Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hey,
I guess you are looking for the SWITCH() function:
https://msdn.microsoft.com/en-us/library/gg492166.aspx
Hope this helps
Hey,
I guess you are looking for the SWITCH() function:
https://msdn.microsoft.com/en-us/library/gg492166.aspx
Hope this helps
Yes! I rewrote it as
Deadline = SWITCH([CASEPRIORITY],"1",[CRITICALRESPONSETIME],"2",[URGENTRESPONSETIME],"3",[NORMALRESPONSETIME])
and it works prectectly.
Thanks
L
Hi @TomMartens,
Great to hear the problem got resolved! Could you accept the helpful reply as solution to close this thread?
Regards
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |