# Dynamic measure headers

To change the name of a measure, double-click on the measure header and rename it to a relevant name. Plan also offers capabilities to dynamically generate headers, which we will explore in this section.

### i) Use predefined functions

Plan includes predefined functions that can be used to create dynamic headers. To view the list of available functions and to append to the header, double-click the header, press Space, then press Ctrl + space bar.

<figure><img src="/files/aW8fkbt5fwwSNcVLV1gA" alt=""><figcaption><p><br><mark style="color:$info;">Predefined functions for headers</mark><br></p></figcaption></figure>

On selecting the 'Month' option, the month name is appended to the measure header.

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

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(709).png" alt=""><figcaption><p><mark style="color:$info;">Month name appended to header</mark></p></figcaption></figure>

#### Using Operators with predefined functions

We can also use operations such as + or - in conjunction with predefined functions. In the example below, we are using the + operator to access the next month.

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

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(712).png" alt=""><figcaption><p><mark style="color:$info;">Using operators with predefined functions</mark></p></figcaption></figure>

Using the + operator, the next month has been dynamically appended to the measure headers.

<figure><img src="/files/awC5TwrzjuFMLB6H2QcQ" alt=""><figcaption><p><mark style="color:$info;">Operator is used in the header</mark></p></figcaption></figure>

#### Setting the fiscal period

The accounting period can be defined using the ‘Fiscal year start month’ option in the Misc tab under Appearance > Settings. The built-in FISCAL\_QUARTER() function will return the quarter based on the defined start month.

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

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(715).png" alt=""><figcaption><p>Fiscal year start month setting</p></figcaption></figure>

Notice how the fiscal quarter is set to Q1 in the measure header on choosing November as the fiscal year start month.

<figure><img src="/files/1epda4T9AvgpGy0SBDE6" alt=""><figcaption></figcaption></figure>

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(716).png" alt=""><figcaption><p>Fiscal quarter based on fiscal year start settings</p></figcaption></figure>

### ii) Reference grid value

We can also directly reference values from the grid in measure headers. To achieve this, double-click on the header to edit it and select the value to be referenced from the grid.

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

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(717).png" alt=""><figcaption></figcaption></figure>

In the next section, we'll cover some [basic actions](/planning/working-with-lumel-epm/3.-basic-interactions/actions.md) such as selections and formatting using rails, toolbar customizations, keyboard shortcuts, and reset.


---

# 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/working-with-lumel-epm/3.-basic-interactions/dynamic-measure-headers.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.
