ELEMENTBYPOSITION

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

js

ELEMENTBYPOSITION(dimension, hierarchy, position)

ELEMENTBYPOSITION(dimension, hierarchy, position)

Parameters

dimension - The name of the dimension.
hierarchy - The name of the hierarchy.
position - The position to return.

Examples

js

ELEMENTBYPOSITION("Time", "Default", 2)

ELEMENTBYPOSITION("Time", "Default", 2)

Result: If the second element in the specified hierarchy is "2018" this will be the return value.