Forum Discussion

samihuq's avatar
samihuq
Icon for Helper III rankHelper III
9 years ago

Generate Forecast Value in a Table

Hi, I have the bellow data set from 01 Jan 2016 to 05 Jan 2016 for 3 products, now need to know if i can generate the forecasted data for 06th and 7th jan 2016? If so then how?   Note: Original da...
Need Help
Show and Tell
Tutorial Requests
samihuq's avatar
samihuq
Icon for Helper III rankHelper III
9 years ago

Thanks Steve,

The tutorial has brilliantly shown the corelation and forecasting, Well i am just kinda worried that, it will get really complicated when i get to introduce multiple dimensions , like Product and Region. Right?

 

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

samihuq,

Yes, it might get complicated - the manual for the "forecast" package is 105 pages!  - but there is some serious statistics behind that to make it a more robust forecasting tool.  And the R integration in Power BI returns a visual, not a table or list of data for further analysis/presentation.

 

Until more forecasting functions are built into Power BI, your only other option for now seems to be creating your own forecast measures - e.g.  see https://community.powerbi.com/t5/Community-Blog/Correlation-Seasonality-and-Forecasting-with-Power-B...