PARALLELPERIOD
Description:
This function is used to return a member from a prior period in the same relative position as a specified member.
Syntax:
ParallelPeriod( [ Level_Expression [ ,Index [ , Member_Expression ] ] ] )
Return type:
MEMBER
Parameters:
Parameter | Description |
|---|---|
Level_Expression | It is a valid MDX expression that returns a level. |
Index | It is a valid numeric expression that specifies the number of parallel periods to lag. |
Member_Expression | It is a valid MDX expression that returns a member. |
Example:
with member [Measures].[P] as
ParallelPeriod ([Date].[Calendar].[Calendar Year]
, 3
,[Date].[Calendar].[Calendar Year].&[2014])
SELECT [Measures].[P] ON 0,
[Date].[Calendar].[Date] on 1
FROM [AdventureWorksMF]