CHILDPOSITION

Returns the position of the child element within a specific parent element within a specified dimension hierarchy.

js

CHILDPOSITION(dimension, hierarchy, parent, child)

CHILDPOSITION(dimension, hierarchy, parent, child)

Parameters

dimension - The name of the dimension.
hierarchy - The name of the hierarchy.
parent - The name of the parent element.
child - The name of the child element.

Examples

js

CHILDPOSITION("Time", "Default", "2018")

CHILDPOSITION("Time", "Default", "2018")

Note: Assuming a calendar year time dimension returns the position of the child element of 2018 - January.