Forum Discussion

Ambi's avatar
Ambi
New Member
6 years ago
Solved

Power BI Forecast

Hi Community, Please guide me to forecast monthly Sales(Not as each day, it is as month) for next three months keeping the previous previous four years monthly Sales History. I want the forecast to ...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Icey's avatar
    Icey
    6 years ago

    Hi Ambi ,

    Is this what you want?

    library(gridExtra)
library(quantmod)
library(forecast)
library(tseries)
ARIMA_Sales<-ts(dataset$Sales,start=c(1))
Sales_Forecast<-auto.arima(ARIMA_Sales,seasonal=TRUE)
Predicted_Sales<- forecast(Sales_Forecast, h=10)
Predicted_Sales<-data.frame(coredata(Predicted_Sales))
grid.table(Predicted_Sales)

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi Ambi ,

Is this what you want?

library(gridExtra)
library(quantmod)
library(forecast)
library(tseries)
ARIMA_Sales<-ts(dataset$Sales,start=c(1))
Sales_Forecast<-auto.arima(ARIMA_Sales,seasonal=TRUE)
Predicted_Sales<- forecast(Sales_Forecast, h=10)
Predicted_Sales<-data.frame(coredata(Predicted_Sales))
grid.table(Predicted_Sales)

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.