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