Learn how to manage rolling forecasts by manually closing forecast periods, extending forecast ranges, and configuring actions for closed periods. These settings help maintain forecast accuracy while extending planning horizons for future forecast cycles.
Manually close periods
Select Period in the Model ribbon.
In the Period menu, select Close Period.
Select the Forecast measure to close.
Select the period to close. In this example, the previous month is selected.
Select Custom to define a custom close period range instead of using the predefined period options.
Extend the forecast range
Select Extend Forecast Range to add new forecast periods after the selected closed period.
Select 1 Month as the extension duration.
Select Preview to review the updated forecast range and verify that the forecast extension is applied as expected before saving the change.
Select Save to apply the forecast range extension.
Review the extended forecast periods in the planning sheet. Verify that Jan 2027 has been added and is available for forecast input.
Configure closed period actions
In the Planning ribbon, select Insert Column > Manage measures.
Select the edit icon for the Forecast measure.
Update the closed period range and configure the forecast settings that should apply when periods are closed.
Select the required action for closed periods.
Select Overwrite forecasts to replace forecast values with actual performance data.
Select Retain forecasts to preserve forecast values for closed periods.
Select Update to apply the forecast configuration.
