Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |