Actual vs. Budget Variance Analysis

Anything related to PowerPivot and DAX Formuale
Naz Kaz
Posts: 2
Joined: Sat Jul 11, 2020 2:17 am

Actual vs. Budget Variance Analysis

Postby Naz Kaz » Sat Jul 11, 2020 2:36 am

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
Posts: 1154
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Actual vs. Budget Variance Analysis

Postby MattAllington » Sat Jul 11, 2020 2:37 pm

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”)
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

Naz Kaz
Posts: 2
Joined: Sat Jul 11, 2020 2:17 am

Re: Actual vs. Budget Variance Analysis

Postby Naz Kaz » Tue Jul 14, 2020 3:22 am

Thanks much! :P


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 2 guests