Returns a member from a prior period in the same relative position as a specified member.

Syntax

ParallelPeriod([<Level>],[<NumericExpression>],[<Member>])

Arguments


LevelHierarchy level to compare date from prior periods.
Numeric_ExpressionInteger number. Difference between current and prior period
MemberSelected/displayed member.

Examples

ParallelPeriods returns the member in same relative position as the specified member that can be used to find some measure value for a prior period.

For example, if year 2018 is selected in report  ParallelPeriod( [Time].[2018],1,[Time].CurrentHierarchyMember) 

 will return a member:

{
  [Time].[2017]
}