How to calculate actual versus budget in Power BI

[texasguy66]

Hello,

I am new to BI and slowly learning how to use it. My source data is an excel file and I have a specific column that indicates if the line is actual or budget. How can I have BI calculate a variance $?

Thanks

 

[ExcelToDAX]

Assuming your table is named Table1, you will want to create 3 measures:

• Budget
  • Budget = CALCULATE(SUM(Table1[Amount $]),FILTER(Table1,[Act/Bud]="Budget"))
• Actuals
  • Actuals = CALCULATE(SUM(Table1[Amount $]),FILTER(Table1,[Act/Bud]="Actual"))
• Variance
  • Variance = [Budget]-[Actuals]