Document toolboxDocument toolbox

ParallelPeriod

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]
}