Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.
Anonymous
Not applicable

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

 

 

Anonymous
Not applicable

@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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.