Return to: Calculated Member Builder Function List
Returns the member that is a specified number of positions following a specified member along the member's dimension.
«Member».Lead(«Numeric Expression»)
Member positions in the dimension are determined by the dimension’s natural order. The numbering of the positions is zero-based.
If «Numeric Expression» is zero, «Member» is returned. If «Numeric Expression» is negative, a prior member is returned.
Lead(1) is equivalent to NextMember. Lead(-1) is equivalent to PrevMember.
The function «Member».Lag is similar, except that it looks in the opposite direction. Lead(n) is equivalent to Lag(-n).
If the levels in the Time dimension include Year and Month, then:
[1994].November.Lead(3)
returns [1995].February.