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)

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)

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

Result: "2021"