Clarity

 View Only

variance between Forecast and Budget in power BI

  • 1.  variance between Forecast and Budget in power BI

    Posted May 18, 2020 06:56 PM
    hoping someone here can provide help. I have built a custom Power BI report using a matrix format, showing both Forecast and Budget (able to differentiate by filtering on plan type), however I cannot seem to be able to create a new measure to show the variance between the 2. I have tried all sorts of formulas as per instructions from Power Bi forums, latest one I used is below, however it does not work.

    Variance =

    CALCULATE (

        SUM(DWH_FIN_PLAN_SUMMARY_FACTS[PLAN_COST] ),

         DWH_FIN_PLAN[FIN_PLAN_TYPE_KEY] = "Budget"

    )

        - CALCULATE (

            SUM(DWH_FIN_PLAN_SUMMARY_FACTS[PLAN_COST] ),

            DWH_FIN_PLAN[FIN_PLAN_TYPE_KEY] = "Forecast"

        )

    Any ideas on how to create this? 
    Thanks.
    Dana