Actual vs. Budget Variance Analysis

[Naz Kaz]

Hi All,

I'm new to DAX and trying to create a P&L. I am stuck on a measure that I can use to do an actual vs budget variance. My actual and budget data is all in one column in the table, is it possible to create a measure that will give me the variance? I can split up the two on the pivot table with the help of a scenario table but cannot subtract them since they are in the same column in the table.

[MattAllington]

You are probably well advised to read a book or so some formal learning. You can use calculate to do what you need. Something like this (depending on your data)

CALCULATE(sum(table[amount]),Table[type]=“actual”) - CALCULATE(sum(table[amount]),Table[type]=“budget”)

[Naz Kaz]

Thanks much!