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:
WITH MEMBER [Measures].[Previous Month Sales] AS
([Measures].[Internet Sales Amount], [Date].[Calendar].CurrentMember.Lag(1))
SELECT
{[Measures].[Internet Sales Amount], [Measures].[Previous Month Sales]} ON COLUMNS,
[Date].[Calendar].[Month].Members ON ROWS
FROM [AdventureWorksMF_ValueBased]