Forum Discussion

mbudiman's avatar
mbudiman
Icon for Helper III rankHelper III
10 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
    10 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
10 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.

Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
10 months ago

✅ How to fix it

You can tell Power BI not to summarize this column.

Steps:

  1. In the Fields pane, find your column NumQuarter.

  2. Right-click on it (or click the small arrow next to it).

  3. Select “Default summarization” → “Do not summarize”.