Help with measure that will show the forecast for the next 12 months

Maln — Thu, 30 Mar 2023 16:30:20 GMT

Hello,

I am looking for a solution to creating a metric to predict the needs (forecast) of an item for use in a linear visualisation or in a table. I tried to use forecasting in visualisation, but the data is too irregular...

For the x-axis data, I am using years and months and this metric is Sale & Cons Qty. for the Y axis. This gives a nice visualisation of how items are sold or consumed in the time period, from here I would like to add forecasting from today forward to the next 12 months.

Currently these are my measures:

Same period last year = CALCULATE( [Sale & Cons. Qty.], SAMEPERIODLASTYEAR(dim_Dates[Date])) Forecast_CM-PYM = DIVIDE( ([Sale & Cons. Qty.] - [Same period last year]),[Same period last year])

From here i would like to somehow get forecasting for only upcoming 12 months (secondary line in visualization)
Bacisly what i am trying to achive is calculation:
From measure Forecast_CM-PYM I get the % diff, between same months in this and previous year.
Here i am missing one measure which would give me average Forecast_CM-PYM % for the current year.

Form this new measure i would than add previous years months data - and this would give me some basic forecasting for upcoming 12 months. And this measure should only be calculated from today to next 12 months (so the line would continue from Sale & Cons. Qty to Forecasting)

something like this:

Thanks for the help
BR, Maln

topic Help with measure that will show the forecast for the next 12 months in DAX Commands and Tips

Help with measure that will show the forecast for the next 12 months