Reforecasting

Reforecasting lets you update forecast periods using values from existing periods as a baseline. You can copy values from a source period to a target period and then apply adjustments, such as growth assumptions, to create an updated forecast with extending time.

Reforecasting is useful when you extend the forecast horizon (planning period) after closing a period and need to seed the newly opened period with the latest actual values. Alternatively, it also allows you to retain the forecast values fed previously in the closing period.

How reforecasting works#

Reforecasting follows these steps:

  1. Close the completed period and extend the forecast horizon.
  2. Select the newly opened forecast period as the target period.
  3. Select the measure and source period to use as the baseline.
  4. Copy the source values to the target period.
  5. Apply adjustments to the target values, such as a growth assumption.

When to use reforecasting#

Use reforecasting when you need to:

  • Input values in the opened forecast period with values from an existing period.
  • Use recent actuals as a baseline for future forecasts.
  • Update forecast values after closing a period.
  • Apply growth assumptions to newly seeded forecast values.
  • Maintain a continuous forecast horizon as actual periods become available.
  • To distribute forecast deficit value to open period in the forecast measures.

Key Takeaway#

Reforecasting lets you use existing planning values to seed future forecast periods and apply updated assumptions. When you combine reforecasting with period closing and forecast extension, you can maintain a continuous forecast horizon as actuals become available. Deficit distribution also comes handy when you want to retain the total (original) forecast for the year by spreading the delta in the open period.

Fabric Plan
Enterprise planning, Integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co Engineered with Lumel.
BUILT ON