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 ,
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.