cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
samihuq
Helper III
Helper III

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

 

DateProductRate
01-Jan-16A15
02-Jan-16A13
03-Jan-16A9
04-Jan-16A13
05-Jan-16A13
01-Jan-16B15
02-Jan-16B9
03-Jan-16B14
04-Jan-16B9
05-Jan-16B6
01-Jan-16C6
02-Jan-16C14
03-Jan-16C10
04-Jan-16C6
05-Jan-16C8
06-Jan-16A?
06-Jan-16B?
06-Jan-16C?
07-Jan-16A?
07-Jan-16B?
07-Jan-16C?

 

Thanks,

Sami

9 REPLIES 9
BhaveshPatel
Community Champion
Community Champion

@samihuq

 

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

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

@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

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?

 

 

@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
Solution Specialist
Solution Specialist

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

 

 

 

 

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
Solution Specialist
Solution Specialist

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

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
Resident Rockstar
Resident Rockstar

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 , 

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

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.

Top Solution Authors
Top Kudoed Authors