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

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

Forecast Difference from Prev(4).pbix46 KB

Forum Discussion

Calculate difference between versions of Forecast data

Related content

Dynamic Calculation Different Period

Version control

Different Calculations

Calculating Differences

How to add two different calculated columns of two different table