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 data set has more then three years data with 500 products.
The new forecasting Feature seems to does this but it does not give me the data in a tabular structure, so was wondering if i could genrate it.
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-B...
As @BhaveshPatel points out, you can generate forecasts from Power BI with R right now. The following links may help:
And note the Known Limitations with R in Power BI: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-r-visuals/#known-limitations
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...
you can see tabular data by right click on visual (Line chart) and "See data" or "Export data" on upper right corner three dots.
But you can't do forecasting together by date and product.
Thanks for the super fast responds. Yes I could Export the file but unfortunately, it only exports the Total Forecast only, any idea if there is a way to export forecast for all products at the same time?
unfortunately not. I had tried to to export also product forecast when i replied to you for the first time, but I hadn't found any way to do that.
Thanks Man, Just Posted it in Idea Forum, hope it will get neccesasary attentions.
Forescast will work with oinly date and Measure , It won't work with other Dimesions sorry 😞
But your goal is good and make sense too.
better raise a Idea ,
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.