Forum Discussion

Pepe1234's avatar
Pepe1234
Frequent Visitor
2 years ago

Acumulative inflation

Hi, I'm trying to calculate cumulative inflation, month by month for unit price forecast (DAX not Power Query).   I need two columns:       - one column with cumuative_inflation (I tried with "Pro...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

Pepe1234 , Try with a common date table

 


Cumulative_Inflation =
CALCULATE(
PRODUCTX(FORECAST_TABLE, 1 + [INFLATION]),
FILTER(all(Date), Date[DATE] <= max(DAte[DATE]))
)

Unit_Price_Forecast =
VAR LatestPrice = calculate(Max(SALES_TABLE[UNIT_PRICE]), FILTER(all(Date), Date[DATE] = max(DAte[DATE])))
RETURN
[Cumulative_Inflation] * LatestPrice