The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, I have been trying to solve this problem on PowerBI for the past hours but nothing seems to work. Here is my script:
Where are you plotting to? Your code is missing the reference to the built-in plotting library.
I have modified my code to this:
# The following code to create a dataframe and remove duplicated rows is always executed and acts as a preamble for your script:
# dataset <- data.frame(Year, Sales revenue (£m))
# dataset <- unique(dataset)
# Paste or type your script code here:
# time series forecasting
dataset <- unique(dataset)
library(forecast)
# Assume the data starts from the first year available and increments yearly
sales_ts <- ts(dataset$`Sales revenue (£m)`, start = min(dataset$Year), frequency = 1)
# Fit an ARIMA model
fit <- auto.arima(sales_ts, seasonal = TRUE) # If seasonality might be a factor
# Forecast the next 5 years
future <- forecast(fit, h = 5)
# Plot the historical data and forecasts
plot(future)
This the plot:
I'm not sure why there is a gap between the historical data and the forecast
User | Count |
---|---|
36 | |
15 | |
12 | |
11 | |
9 |
User | Count |
---|---|
45 | |
44 | |
19 | |
18 | |
18 |