Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Empty table when defining time series in R script

Hello,

 

I am trying to forecast sales using an R script. The R script works fine in R Studio but returns an empty table when used in Power BI.

 

Here is my data:

WeekUnit
1/3/2018355263
1/10/2018398547
1/17/2018332485
......

 

"Week" is formatted as a date and "Unit" is formatted as a number.

 

I use the following code:

 

library(dplyr)
library(forecast)
library(lubridate)
 
salesTS <- ts(dataset$`Unit`, frequency = 52, start = 2018)

salesLog <- log(salesTS)

salesLogHW <- HoltWinters(salesLog)

nextYearSales <- forecast(salesLogHW, h=52)

 

 "This table is empty" is displayed after I try to transform the dataset to time series.

 

Does anyone know how I can make my code work and obtain a forecast for 52 weeks ahead?

 

Thanks,

Alona

1 Reply

  • where are the week dates in your R script? (the "week"  column)