Analysis Services
Lag
Returns the member that is a specified number of positions prior to a specified member along the dimension of the member.
Syntax
«Member».Lag(«Numeric Expression»)
Remarks
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).
Example
If the levels in the Time dimension include Year and Month, the following example returns [1994].November:
[1995].February.Lag(3)