Generate Forecast Value in a Table

Question

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?&nbsp;Note: Original data set has more then three years data with 500 products.&nbsp;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.&nbsp;DateProductRate01-Jan-16A1502-Jan-16A1303-Jan-16A904-Jan-16A1305-Jan-16A1301-Jan-16B1502-Jan-16B903-Jan-16B1404-Jan-16B905-Jan-16B601-Jan-16C602-Jan-16C1403-Jan-16C1004-Jan-16C605-Jan-16C806-Jan-16A?06-Jan-16B?06-Jan-16C?07-Jan-16A?07-Jan-16B?07-Jan-16C?&nbsp;Thanks,Sami

bhaveshpatel · Answer

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

anonymous · Answer

samihuq,You CAN do forecasting with DAX, but it looks like pretty hard work just now - see&nbsp;https://community.powerbi.com/t5/Community-Blog/Correlation-Seasonality-and-Forecasting-with-Power-BI/ba-p/14147&nbsp;As&nbsp;BhaveshPatel&nbsp;points out, you can generate forecasts from Power BI with R right now. &nbsp;The following links may help:https://community.powerbi.com/t5/R-Script-Showcase/Forecasting/td-p/58485http://www.datamic.net/blog/dynamic-forecasting-with-power-bi-and-r&nbsp;And note the Known Limitations with R in Power BI:&nbsp;https://powerbi.microsoft.com/en-us/documentation/powerbi-service-r-visuals/#known-limitations

pavelr · Answer

Hi&nbsp;samihuq&nbsp;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.&nbsp;RegardsPavel

baskar · Answer

Forescast will work with oinly date and Measure , It won't work with other Dimesions sorry :-(&nbsp;But your goal is good and make sense too.&nbsp;better raise a Idea ,&nbsp;

pavelr · Answer

Hi&nbsp;samihuq&nbsp;you can see tabular data by right click on visual (Line chart) and "See data" or "Export data" on upper right corner three dots.&nbsp;But you can't do forecasting together by date and product.&nbsp;Regards.Pavel&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Generate Forecast Value in a Table

9 Replies

Related content

Forecasting with DAX

Generating Missing Data

Forecasting

SUMMARIZE, VALUES, and other table generation/manipuation with field parameters

Calculating a Forecast value

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	?