Forum Discussion
Solved
Calculating New Columns
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!
a simple MEASURE should do the job
MEASURE=sum(TableName[Budget])-sum(tableName[Actual])
1 Reply
a simple MEASURE should do the job
MEASURE=sum(TableName[Budget])-sum(tableName[Actual])