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

Syntax

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

Arguments

Level	Hierarchy level to compare date from prior periods.
Numeric_Expression	Integer number. Difference between current and prior period
Member	Selected/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]
}

Browser not supported