Time Series Forecasting in Power BI
We are now ready to create our Sales Forecast measure:
Sales Forecast = [Sales Forecast - Seasonality] + [Sales Forecast - Trend]
Actualized Forecasted Revenue measure is meant to display actual values for data points where we have history and forecast for data points in the future
Actualized Forecasted Revenue = var _sales = [Revenue] RETURN IF(_sales<>0, _sales, [Sales Forecast])