fbpx

Lag (MDX)

Returns the member that is at the specified number of positions before the specified member along its level.

Parameters

Name Type Cardinality Default value
  numeric-expression  one   

Return

member

Description

This function allows for 'traveling' backwards in the members' level hierarchy member's list.

The following holds true : Lag(1) = prevMember = Lead(-1).

If the number of specified position is out of bounds, the function returns the null member.

Equivalent to lead(-index)

See Also

Lead PrevMember NextMember

Examples

Special Examples (errors, null, ...)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.