Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
104 | |
92 | |
88 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |