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 all,
I am fairly new to Power BI. I have a table in Power BI Desktop and am trying to calculate a variance between the Budget and Actual Costs that sums automatically. See sample table in Excel belowBudget and Actual Cost are from two different tables with Division serving as the relationship between the two. Any suggestions on how to calculate this difference?
Thanks!
Solved! Go to Solution.
a simple MEASURE should do the job
MEASURE=sum(TableName[Budget])-sum(tableName[Actual])
a simple MEASURE should do the job
MEASURE=sum(TableName[Budget])-sum(tableName[Actual])
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |