Generate Forecast Value in a Table

[samihuq]

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 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.

Date	Product	Rate
01-Jan-16	A	15
02-Jan-16	A	13
03-Jan-16	A	9
04-Jan-16	A	13
05-Jan-16	A	13
01-Jan-16	B	15
02-Jan-16	B	9
03-Jan-16	B	14
04-Jan-16	B	9
05-Jan-16	B	6
01-Jan-16	C	6
02-Jan-16	C	14
03-Jan-16	C	10
04-Jan-16	C	6
05-Jan-16	C	8
06-Jan-16	A	?
06-Jan-16	B	?
06-Jan-16	C	?
07-Jan-16	A	?
07-Jan-16	B	?
07-Jan-16	C	?

Thanks,

Sami

[BhaveshPatel]

@samihuq

You can use forecast package in R and R script in PowerBI to get the results you are looking for.

[Anonymous]

@samihuq,

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:

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?

[Anonymous]

@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...

[PavelR]

Hi @samihuq

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.

Regards.

Pavel

[samihuq]

Hey Pavel,

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? 

Chhers,
Sami

[PavelR]

Hi @samihuq

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.

Regards

Pavel

[samihuq]

Thanks Man, Just Posted it in Idea Forum, hope it will get neccesasary attentions.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17583448-forecast-multiple-dimens...

Regards,

Sami

[Baskar]

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 ,