Syntax

member.Lag (index [,layertype ] [, hierarchy ] )

or

Lag ( member, index [, hierarchy ] )

Parameters

member

The starting member from which .LAG counts to a given number of previous members.

index

A number n representing how many steps prior to <member> to count.

layertype

GENERATION or LEVEL. Generation is the default.

hierarchy

Optional. A specific hierarchy within the time dimension.

Notes

• If the member specified by the Lag function does not exist, the result is an empty member. For example, using Sample Basic, [Jun].lag (12) returns an empty member.

• When multiple hierarchies are enabled, this function returns NULL when the source member is in one hierarchy and the result member belongs to a different hierarchy.

Example

The following expression:

[Jun].lag (3)

returns the member that is 3 steps prior to Jun:

[Mar]

The following expression:

[Jun].lag (-3)

returns the member that is 3 steps following Jun:

[Sep]

For every month, the following query displays the sales and average over the last three months:

WITH MEMBER
 [Measures].[Average Sales in Last 3 months]
AS
'Avg(
     {[Year].CurrentMember,
      [Year].CurrentMember.Lag(1),
      [Year]. CurrentMember.Lag(2)
     }, 
     [Measures].[Sales]
 )'
SELECT 
 {[Measures].[Sales], 
  [Measures].[Average Sales in Last 3 months] 
 } 
ON COLUMNS,
 [Year].Levels(0).Members
ON ROWS
FROM Sample.Basic

The above query returns the following grid:

See Also

Lead

PrevMember