ParallelPeriod

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


The following formula can be used to calculate a created issues in the same period (as selected) one year ago.

(
	[Measures].[Issues created],
	ParallelPeriod(
		[Time].CurrentHierarchy.Levels('Year'), 1, 
		[Time].CurrentHierarchyMember
	)
)