DE.INDEX

Returns the index number of the specified element within the specified dimension.

DE.INDEX is one-based. It returns 1 for the first element in the dimension. If the element is not found, the function returns 0.

Syntax

DE.INDEX(Dimension, Element)

Example

The fourth element in the REGION dimension is Angola, so this example returns 4:

DE.INDEX('REGION','Angola')