# 10. Integrating forecasts

You can have historical and current data in one Planning sheet and may have configured your forecasts in a different Planning sheet. Plan can detect and seamlessly integrate future periods from a bridge. Let's look at how to integrate forecasts with Infobridge.

To demonstrate this feature, we created a Forecast for 2025. [Learn more about forecasting with Plan](https://github.com/lumelinc/PowerTableDocs/blob/main/working-with-inforiver/7.-planning-budgeting-and-forecasting).

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(269).png" alt=""><figcaption><p>Creating an Plan forecast</p></figcaption></figure>

The target visual contains historical/current sales for 2022, 2023, and 2024. Let's look at how to import the 2025 forecast from the previous visual into this target report.

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(2243).png" alt=""><figcaption><p>Target visual with current and historical data</p></figcaption></figure>

**STEP 1:** Create a bridge to access the forecast data from the visual. We have created a bridge titled FC2025.

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(2241).png" alt=""><figcaption><p>Creating a bridge for the forecast</p></figcaption></figure>

**STEP 2:** Create an Infobridge integration to the FC2025 bridge to access the forecast.

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(268).png" alt=""><figcaption><p>Creating an Infobridge integration</p></figcaption></figure>

**STEP 3**: Use the Insert Measure option, to insert the forecast measure from the bridge into the target visual. Notice how Plan creates the time extension without any manual intervention.

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(2244).png" alt=""><figcaption><p>Inserting the forecast measure from the bridge</p></figcaption></figure>

The 2025 forecast is imported into the target report:

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(2245).png" alt=""><figcaption><p>Forecast inserted with seamless time extension</p></figcaption></figure>

{% hint style="info" %}
The forecast columns inserted for previous years will be blank. We’ve hidden them using the column gripper options.
{% endhint %}


---

# 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/infobridge/10.-integrating-forecasts.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.
