ParallelPeriod
EAZYBI Returns a member from a prior period in the same relative position as the given member.
Syntax
ParallelPeriod(Level_Expression, Numeric_Expression, Member_Expression)
Arguments
Level_Expression | Hierarchy level expression across which the parallel period will be returned. |
---|---|
Numeric_Expression | MDX expression that returns an integer number. The difference between the current and the previous parallel periods. |
Member_Expression | Member expression for which to find the parallel period. |
Example
ParallelPeriods
returns the member in the same relative position as the specified member that can be used to find some measure value from a prior period.
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 ) )