# Forecast data to predict future trends

Forecasting capabilities in the Planning sheet enable organizations to move beyond static annual plans and adopt agile planning methods, such as rolling forecasts and periodic re-forecasting. Use forecasting to project revenue, expenses, and other metrics for upcoming periods based on historical data. 

Create dynamic forecasts directly on semantic models and update them as new actuals become available. Forecasts can be generated using multiple approaches, such as copying historical values, applying averages, or manually adjusting projections.

### Prerequisite <a href="#prerequisites" id="prerequisites"></a>

The column dimension is a standard date hierarchy (for example, year > quarter > month).

### Define initial forecast settings <a href="#prerequisites" id="prerequisites"></a>

The first step in configuring a forecast is to set the time frame for which the forecast is generated. Then configure how to populate static values in the forecast measure for past or closed periods. For instance, if you have actuals for 2025 and are generating a forecast for 2026, a static forecast measure will be created for 2025.&#x20;

{% hint style="info" %}
The forecast measure for previous periods cannot be edited. Static values for closed forecasts can be sourced from a measure in your planning sheet by setting **Closed Period** to **Measure**. Set **Closed Period** to **Formula** to define a formula to populate closed periods.
{% endhint %}

1. Go to **Model** > **Forecast** to create a forecast.
2. Set the start and end date of the forecast period.
3. Choose how to fill closed forecasts. Set **Closed Period** to **Formula** and enter the formula. When creating a formula, you can reference other measures in the planning sheet.

<figure><img src="/files/16DJynvtrrhIuNeXws5p" alt=""><figcaption></figcaption></figure>

Static closed forecasts are populated using the specified formula.

<figure><img src="/files/lSzywCokI3Mn5JZFMuNG" alt=""><figcaption></figcaption></figure>

### Options to populate open forecasts <a href="#create-a-forecast" id="create-a-forecast"></a>

Generate open forecasts using one of these methods:

* **Measure**- If measure values exist for an open period, use those values to populate the forecast.
* **Formula**- If measure values exist for an open period, use a formula based on those values to populate the forecast.
* **Data Input**- Allow users to enter forecasts.

<figure><img src="/files/Zv7JXEgReRkN7BlT01gd" alt="" width="563"><figcaption></figcaption></figure>

When open forecast measures are configured as **Data Input**, you can initialize the forecast using historical or current data. If the source data contains blank values, configure a default value using one of the options shown.

{% hint style="info" %}
When a measure or formula is selected as the default value, ensure that data is available for the forecast period.
{% endhint %}

<figure><img src="/files/4HNOQkPuqWMSZEIb0VTp" alt="" width="563"><figcaption></figcaption></figure>

### Populate open forecasts from the data source <a href="#create-a-forecast" id="create-a-forecast"></a>

If forecast values are already available for future periods in the data source, you can populate open periods using the native forecast measure or a formula that references it.

To initialize the open forecast from a measure in the planning sheet, set **Open Period** to **Measure**, then select the measure from **Linked Measure**.

To set forecast values based on a formula, set **Open Period** to **Formula** and enter the formula.

<figure><img src="/files/fh1FrAeajdf4XPs86P3H" alt="" width="563"><figcaption></figcaption></figure>

Consider a business case where the revenue projections are available for the forecast period, in this case, 2026.

<figure><img src="/files/8gXlFbk48Y1djQowFatv" alt=""><figcaption></figcaption></figure>

To create a forecast based on a formula, set **Open Period** to **Formula** and enter the formula.

<figure><img src="/files/wFHxZ9JlETO55NFi0nPB" alt=""><figcaption></figcaption></figure>

Create and save the forecast.

<figure><img src="/files/qyHKRVO4RQ2CyqnnvbsQ" alt=""><figcaption></figcaption></figure>

### Initialize a forecast using historical or current data

Prepopulate future forecast periods using existing historical or current data. These initial values can then be manually adjusted by selecting and editing the cell.

1. Set **Open Period** to **Data Input** and **Default Value** to **None.**

{% hint style="info" %}
If the measure used to initialize the forecast contains null values, you can replace them with a default value. The default value can be a static value, another measure, or a formula.&#x20;
{% endhint %}

2. Select **Create**.

<figure><img src="/files/ftbhE8BZJAToFHskQqqf" alt="" width="563"><figcaption></figcaption></figure>

3. In **Period Setup**, From **Copy Source**, select the measure to use to prepopulate the forecast.
4. **Apply Operation** is set to **Period Range,** and **Source Periods** are automatically populated. The Revenue measure from January–December 2025 is used to initialize the forecast for January–December 2026.

{% hint style="info" %}
The period range duration should match the target period duration. E.g., if the target period is 6 months, then you must select a period range spanning 6 months.
{% endhint %}

<figure><img src="/files/qDSRQ4nLX9tNm3xAgY2f" alt="" width="563"><figcaption></figcaption></figure>

The forecast is initialized using revenue from the corresponding month in the previous year.

<figure><img src="/files/dK7oPScwp9Uv2Znz4UVC" alt=""><figcaption></figcaption></figure>

* To initialize forecasts with the average measure value over a specified period range, set **Apply Operation** to **Average of Period Range** and select the timeframe from **Source Periods**.

<figure><img src="/files/uQClrbkOGXpmyz1Wu8eX" alt="" width="563"><figcaption></figcaption></figure>

The average revenue from Q4 2025 is used to initialize each month in the 2026 forecast.

<figure><img src="/files/zJfLmamddI4fjxiqlXAm" alt=""><figcaption></figcaption></figure>

* To initialize forecasts with measure values from a single period, set **Apply Operation** to **Single Period** and select the period.

<figure><img src="/files/PwP54ld1E3aaeujBjT9b" alt="" width="563"><figcaption></figcaption></figure>

The revenue from December 2025 is used to initialize each month in the 2026 forecast.

<figure><img src="/files/mP3k6wduJVhrsn4zFcIx" alt=""><figcaption></figcaption></figure>

### Initialize forecast ranges using different methods

Split a forecast period into multiple ranges and initialize each range using a different method, such as average values or data from a prior period.

{% hint style="info" %}
This option is available only when **Open Period** is set to **Data Input**.
{% endhint %}

1. Configure the initial forecast settings, then go to **Period Setup.**
2. Set the **Target Period** to January-March 2026, **Copy Source** to the Revenue measure, **Apply Operation** to **Single Period**, and **Source Periods** to December 2025.

<figure><img src="/files/VrUYlv17jANOVUrg33gh" alt="" width="563"><figcaption></figcaption></figure>

3. Select **Add Range**.
4. Set the **Target Period** to April-June 2026, **Copy Source** to the Revenue measure, **Apply Operation** to **Average of Period Range**, and **Source Periods** to January-December 2025.

<figure><img src="/files/FPzYevDk9jNGHpvSaK0d" alt="" width="563"><figcaption></figcaption></figure>

5. Select Add Range.
6. Set the **Target Period** to July-August 2026, **Copy Source** to the Revenue measure, **Apply Operation** to **Period Range**, and **Source Periods** to November-December 2025.

<figure><img src="/files/In6fpQPxtSYHSItiPE5E" alt="" width="563"><figcaption></figcaption></figure>

The 2026 forecast is split into multiple ranges based on the period setup configurations:

* The forecast for January-March 2026 is initialized from the December 2025 revenue.

<figure><img src="/files/c1leJKWbbx4N8nZYgBPI" alt=""><figcaption></figcaption></figure>

* The forecast for April-June(Q2) 2026 is created from the average revenue from 2025.

<figure><img src="/files/O72wf3ojDrDx6uur9pva" alt=""><figcaption></figcaption></figure>

* The forecast for July-August 2026 is based on the revenue from November-December 2025.

<figure><img src="/files/rcWeqYLcMiOSEm9oVkD0" alt=""><figcaption></figcaption></figure>

* The forecast values for September through December 2026 are blank because no initial value is configured in the Period Setup.

### Update open forecasts

After a forecast is created, its initial values can be modified at any time. If the open forecast has been split into multiple periods, you can update the values for a specific period without affecting the configured values for the other periods.

1. Select **Reforecast** > **Reforecast Column.**
2. Define the period range used to update the open forecast.
3. Select the measure and method to populate the forecast.

<figure><img src="/files/GQqX1HfLhWqu3sxw1Ruv" alt=""><figcaption></figcaption></figure>

The new configuration is applied to the July forecast.

<figure><img src="/files/yLKX5keXih18v9zebAr2" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.fabricplan.com/planning-sheets/how-tos/forecast-data-to-predict-future-trends.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.