Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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])
User | Count |
---|---|
65 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
120 | |
41 | |
40 | |
28 | |
23 |