All eazyBI for Jira eazyBI for Confluence Private eazyBI

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