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].[Last Year Sales] AS
([Measures].[Internet Sales Amount],
ParallelPeriod([Date].[Calendar].[Calendar Year], 1, [Date].[Calendar].CurrentMember))
MEMBER [Measures].[YoY Growth] AS
([Measures].[Internet Sales Amount] - [Measures].[Last Year Sales]) / [Measures].[Last Year Sales],
FORMAT_STRING = 'Percent'
SELECT {[Measures].[Internet Sales Amount], [Measures].[Last Year Sales], [Measures].[YoY Growth]} ON
COLUMNS,
[Date].[Calendar].[Month].Members ON ROWS
FROM [AdventureWorksMF_ValueBased]