Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

Arguments

Member_ExpressionMDX 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.

...

Code Block
Sum(
  { PreviousPeriods([Time].CurrentHierarchyMember),
   [Time].CurrentHierarchyMember },
  [Measures].[Invoice count]
)

...