Forum Discussion

rsharma81's avatar
rsharma81
Regular Visitor
2 years ago
Solved

Actual vs Forecast vs Budget Variance

Hi Team,   I am currently working in Power BI to see the variance in Matrix table for Actuals vs Budget and Actuals vs Forecast. as per the below screenshot for sample data.   I am attaching here...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi rsharma81 - Calculate variances between Actuals vs Budget and Actuals vs Forecast in a Power BI Matrix table, you need to create measures that calculate these variances.

     

    create measures for each, like actual , budget and forcast

     

    Actual =
    CALCULATE(
    SUM(SalesData[Amount]),
    SalesData[Scenario] = "Actual"
    )

     

    Variance =
    [ActualAmount] - [BudgetAmount]

    or 

    Varience = CALCULATE(SUM(FAB[Amount]),FAB[Scenerio]="Actual")-CALCULATE(SUM(FAB[Amount]),FAB[Scenerio]="Budget")

     

     

     

    adjust the totals from format column subtotals as highlighted

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

     

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

Hi rsharma81 - Calculate variances between Actuals vs Budget and Actuals vs Forecast in a Power BI Matrix table, you need to create measures that calculate these variances.

 

create measures for each, like actual , budget and forcast

 

Actual =
CALCULATE(
SUM(SalesData[Amount]),
SalesData[Scenario] = "Actual"
)

 

Variance =
[ActualAmount] - [BudgetAmount]

or 

Varience = CALCULATE(SUM(FAB[Amount]),FAB[Scenerio]="Actual")-CALCULATE(SUM(FAB[Amount]),FAB[Scenerio]="Budget")

 

 

 

adjust the totals from format column subtotals as highlighted

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!