Lag

Lag

SQL Server 2000

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)
Show:
© 2016 Microsoft