Calculating New Columns

[powerbilearner9]

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!

[Zubair_Muhammad · Accepted solution]

Hi @powerbilearner9

a simple MEASURE should do the job

MEASURE=sum(TableName[Budget])-sum(tableName[Actual])