Page Comparison

Returns a set of previous time dimension members for calculation of cumulative sums.

...

 PreviousPeriods(Member_Expression)

Arguments

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