Return to: Calculated Member Builder Function List
Returns a member from a prior period in the same relative position as a specified member, for example the same relative month in the previous quarter.
ParallelPeriod([«Level»[, «Numeric Expression»[, «Member»]]])
This function is similar to the Cousin function, but is more closely related to Time series. It takes the ancestor of «Member» at «Level» (call it ancestor); then it takes the sibling of ancestor that lags by «Numeric Expression», and returns the parallel period of «Member» among the descendants of that sibling.
This function has the following defaults:
Default «Member» value is Time.CurrentMember if «Level» is not specified. Otherwise it is dimension.CurrentMember, where dimension is the dimension to which level belongs.
Default «Numeric Expression» is 1.
Default «Level» is the level of the parent of «Member».
This function is equivalent to:
Cousin(Member,Lag(Ancestor(Member,Level),Numeric Expression)
| Expression | Returns |
|---|---|
| PARALLELPERIOD(Year,2, [96 Qtr 3]) |
[94 Qtr 3] |
| PARALLELPERIOD(Year,2) | The parallel period of Time.CurrentMember, two years ago.
That is, if Time.CurrentMember is [1993June], then the returned member is [1991June]. |
| PARALLELPERIOD(Year) | The parallel period of Time.CurrentMember from last year.
That is, if Time.CurrentMember is [1993June], then the returned member is [1992June]. |
| PARALLELPERIOD() | The parallel period in the immediately prior sibling to the parent of Time.CurrentMember.
For example, if Time.CurrentMember is [1993June], then the returned member is [1993March]. The parent of ([1993June] is Quarter2, whose immediately prior sibling is Quarter1, in which the parallel period is [1993March]. |