Forum Discussion
Helper IIICalculate difference between versions of Forecast data
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
Helper IIIhi Ahmedx ,
Could you help me again. When I apply your solution, I dont get the same value of NumQuarter. I cant figure out why. Appreciate if you could advise if I miss something. Thank you.
What I did was create new Column for "NumQuarter" with the same formula as your pbix, but result is different. See below.
Super UserIt seems you just need to change the format
- mbudiman
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
✅ How to fix it
You can tell Power BI not to summarize this column.
Steps:
-
In the Fields pane, find your column
NumQuarter. -
Right-click on it (or click the small arrow next to it).
-
Select “Default summarization” → “Do not summarize”.
-
v-saisrao-msftCommunity Support
- mbudiman
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 ?