Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
How can I achieve
when [Service Group Level 0] is "REVENUE" then [Actual Amount]
when [Service Group Level 0] is "COSTS + OVERHEADS" then [Cost Amount]
Solved! Go to Solution.
You can use nested IFs, or the syntax sugar version SWITCH.
Result = SWITCH([Service Group Level 0],"REVENUE",[Actual Amount],"COSTS + OVERHEADS",[Cost Amount])
getting an error. what can be the reason ?
a measure needs an aggregation. use MAX([Service Group Level 0]) , for example.
You can use nested IFs, or the syntax sugar version SWITCH.
Result = SWITCH([Service Group Level 0],"REVENUE",[Actual Amount],"COSTS + OVERHEADS",[Cost Amount])