Returns the member that is a specified number of positions prior to a specified member along the dimension of the member.
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 subsequent member is returned.
Lag(1) is equivalent to PrevMember. Lag(-1) is equivalent to NextMember.
The «Member».Lead function is similar, except that it looks in the opposite direction. Lag(n) is equivalent to Lead(-n).
If the levels in the Time dimension include Year and Month, the following example returns