forecasting

[Trent]

Hi All,

New to Power BI and I am very keen on the forecasting capability. All examples I have seen show a forecast of a single component. If I have 100 products and want to generate forecast for all of those at once in a table that can be extracted and then used for demand planning is that possible?

thanks

[v-qiuyu-msft]

Hi @Trent,

Currently, the forecast feature is available for one line in a line chart, if you put the column to Legend, the Forecast is not available. Besides, we are not able to capture these forecast values to calculate again.

Best Regards,
QiuyunYu

[TomMartens]

Hey,

can you please a little more specific what you mean by "extracted", currently it's not that easy to get data out Power BI or the Service, manual effort is required.

Basically I would use a slightly different approach, assuming I have the table with the base data needed for the forecast, I would use R and the forecast package to create the timeseries for each of your 100products.

Regards