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