Forum Discussion
Helper IIIGenerate Forecast Value in a Table
Super User
You can use forecast package in R and R script in PowerBI to get the results you are looking for.
You CAN do forecasting with DAX, but it looks like pretty hard work just now - see https://community.powerbi.com/t5/Community-Blog/Correlation-Seasonality-and-Forecasting-with-Power-BI/ba-p/14147
As BhaveshPatel points out, you can generate forecasts from Power BI with R right now. The following links may help:
https://community.powerbi.com/t5/R-Script-Showcase/Forecasting/td-p/58485
http://www.datamic.net/blog/dynamic-forecasting-with-power-bi-and-r
And note the Known Limitations with R in Power BI: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-r-visuals/#known-limitations
- samihuq
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?
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...
