Forum Discussion

mbudiman's avatar
mbudiman
Icon for Helper III rankHelper III
11 months ago
Solved

Calculate difference between versions of Forecast data

Hello,   I need help for a DAX measure to calculate Forecast Qty difference between versions for each Fiscal Qtr. A Fiscal Qtr may have multiple versions of Forecast. See example data below.   ...
Need Help
  • Ahmedx's avatar
    Ahmedx
    11 months ago

    and try this 

    Measure = 
VAR NumQuarter = SELECTEDVALUE('Sales Forecast'[NumQuarter])-1
VAR PQTY = 
CALCULATE([FCST_QTY], 'Sales Forecast'[NumQuarter]= NumQuarter , REMOVEFILTERS('DimVersionNo'),REMOVEFILTERS(DimFYFISCAL))
RETURN
 [FCST_QTY] - PQTY

mbudiman's avatar
mbudiman
Icon for Helper III rankHelper III
11 months ago

hi Ahmedx ,

 

Thats not what I meant. The value of NumQuarter for Fiscal Qtr "FY26Q1" and Version_No "1" should always be 20,260,101, but my pbix sum up all the rows of FY26Q1 and Version_No=1 to 78,244,510,062. Because of this, I dont get correct Forecast Qty difference.

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
11 months ago

Hi mbudiman,

Have you had a chance to review the solution we shared by Ahmedx  If the issue persists, feel free to reply so we can help further.

 

Thank you.

  • mbudiman's avatar
    mbudiman
    Icon for Helper III rankHelper III
    11 months ago

    hi v-saisrao-msft 

     

    I still have problem, the solution does not work in pbix. I am trying to figure out why. Do you have other suggestion to derive calculation of difference of Forecast Qty from previous version ?

    • Ahmedx's avatar
      Ahmedx
      Icon for Super User rankSuper User
      11 months ago

      try creating another new column

      • mbudiman's avatar
        mbudiman
        Icon for Helper III rankHelper III
        11 months ago

        Here is my actual pbix data structure with mockup data. When I apply solution suggested by you, it does not work. SalesForecast sample.pbix