LAG
Description:
This function is used to return the member that is a specified number of positions before a specified member at the member's level.
Syntax:
Member_Expression.Lag(Index)
Return Type:
MEMBER
Parameters:
Parameter | Description |
|---|---|
Member_Expression | It is a valid MDX expression that returns a member. |
Index | A valid numeric expression that specifies the number of member positions to lag. |
Example:
SELECT
[Measures].[Internet Order Quanlity] on 0,
[Customer].[Geography].[Country].&[Germany].Lag(2) ON 1
FROM [AdventureWorksMF]