OFFSET ^v2.4.890

Returns the name of the element at a specified index (numeric position) relative to the specified element in a specified dimension hierarchy.

OFFSET(dimension, hierarchy, element, offset)

Parameters

• dimension - The name of the dimension.
• hierarchy - The name of the hierarchy.
• element - The name of the element.
• offset - The relative position to return.

Examples

OFFSET("Time", "Default", "2020", 1)

Result: "2021"