The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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])
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
67 | |
36 | |
21 | |
18 | |
15 |
User | Count |
---|---|
124 | |
39 | |
30 | |
24 | |
22 |