I am trying to reqritethis in DAX.
(IF [CASEPRIORITY] = 1 THEN [CRITICALRESPONSETIME]
ELSEIF [CASEPRIORITY] = 2 THEN [URGENTRESPONSETIME]
ELSEIF [CASEPRIORITY] = 3 THEN [NORMALRESPONSETIME]
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.
Go to Solution.
I guess you are looking for the SWITCH() function:
Hope this helps
Yes! I rewrote it as
Deadline = SWITCH([CASEPRIORITY],"1",[CRITICALRESPONSETIME],"2",[URGENTRESPONSETIME],"3",[NORMALRESPONSETIME])
and it works prectectly.
Great to hear the problem got resolved! Could you accept the helpful reply as solution to close this thread?
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.