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