# VALUEAT

The VALUEAT function returns the value of a measure for a specified date or a date shift relative to the current column. 

## Syntax

```javascript
VALUEAT([measure], <offset interval>)
```

## Arguments

measure – The measure for which data has to be fetched. Required.

offset interval - The preset format model, like month("M"), quarter("Q) or year("Y"). Required.

## Return value

The measure value at a specific point in time.

## Example

```
VALUEAT([Sales], "-1M")
//Returns the sales measure from the preceding month

VALUEAT([Sales], "1Q")
//Returns the sales measure from the next quarter
```

Let's look at a monthly sales report. The VALUEAT function can be applied to return the value of the sales measure for a particular month(s) preceding or after the current month. This is useful in evaluating the financial performance relative to other periods.

<figure><img src="/files/BUU2ofe3xKgbiNVjfQfK" alt=""><figcaption><p>Fetching the measure value for the previous month</p></figcaption></figure>

Similarly, we can fetch the sales value for the next quarter as shown in this example.

<figure><img src="/files/SvOgaxtrxg9JXP7OV03l" alt=""><figcaption><p>Fetching the measure value for the next quarter</p></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.inforiver.com/formula-syntax/time-intelligence-functions/valueat.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.