VALUEAT

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

Syntax

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.

Fetching the measure value for the previous month

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

Fetching the measure value for the next quarter