Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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 "Productx", but it didn´t work.)
- another column with Unit_Price_Forecast (last unit_price available in the sales table)*(cumulative_inflation)
Can you help me?
I expect something like that:
thanks amitchandak, but still the same, take a look:
@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
I expected columns in yellow:
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.