ENUM_LEVEL

In Filtering & data shaping

The ENUM_LEVEL function iterates through the values of the specified levels and returns each value with a number assigned in ascending or descending order according to the sequence in the dimension management.

Use this function when you need to number level values by their position in dimension management, for example to create index columns or define ordering rules independent of measure values.

Parameters

LevelLevel nameRequired

One or more levels whose values are enumerated, specified in double quotes (e.g. "Year", "Country").

OrderKeywordOptional

Whether to enumerate in ascending or descending order. Default: "ASC".

• "ASC": Enumerates in ascending order according to the sequence in dimension management. This is the default.
• "DESC": Enumerates in descending order (last value in dimension management gets number 1).

Watch out

Examples

Enumeration along a single level (ASC and DESC)

This example numbers each year value according to its position in dimension management, first ascending (default) then descending.

Formula: ENUM_LEVEL("Year")

Formula: ENUM_LEVEL("Year", "DESC")

Enumeration across multiple levels

When multiple levels are specified, the alphabetical order of dimension names determines which level takes precedence in the combined enumeration.

Dimensions:

Time → Year

Location → Country

Formula: ENUM_LEVEL("Year", "Country")

In this example "Location" dimension is prioritised over "Time" which starts enumeration with rows having value "France" over "Germany". Within the rows having same value, the "Year" level is used to further break the tie.

See also

ENUM

When you want to enumerate rows by measure value rather than by level order in dimension management.

FINDFIRST

When you want to select one value per group rather than assign ranking numbers.