Returns a member from a prior period in the same relative position as a specified member.
ParallelPeriod ( [layer [,index [,member [, hierarchy ]]]])
Optional layer specification. If omitted, the same layer is assumed.
Number of time periods to count back in the specified layer.
Optional member specification. If omitted, the default member is assumed (for more information, see Defaultmember).
Optional. A specific hierarchy within the time dimension.
with
member measure.XXX as (measure.[sales amount], parallelPeriod())
select
{ (Calendar.[ALL].[2021].Q3.M7), (Calendar.[ALL].[2021].Q4.M10) }
on 0,
{ (measure.XXX) }
on 1
from [Online Store] ;
| M7 | M10 | |
| XXX | 1440 | 7238 |