table of contents

Returns the member that is a specified number of positions prior to a specified member along the dimension of the member.

«Member».**Lag**(«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 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 `[1994].November`

:

```
[1995].February.Lag(3)
```