Returns a set of previous time dimension members for calculation of cumulative sums.
...
PreviousPeriods(Member_Expression)
Arguments
Member_Expression | MDX expression that returns a member. |
---|
Examples
PreviousPeriods
returns optimized set of previous periods that can be used to aggregate some measure value for all previous time periods.
...
The following formula can be used to calculate a cumulative sum of resolved issues invoice count until the previous period:
Sum( PreviousPeriods([Time].CurrentHierarchyMember), [Measures].[IssuesInvoice resolvedcount] )
If we want to calculate a cumulative sum of resolved issues invoice count including the current period then we need to add the current period to the previous periods set:
Sum( { PreviousPeriods([Time].CurrentHierarchyMember), [Time].CurrentHierarchyMember }, [Measures].[IssuesInvoice resolvedcount] )
See also