ParallelPeriod
Returns a member from a prior period in the same relative position as a specified member.
Syntax
CODE
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:
CODE
{
[Time].[2017]
}