|Member_Expression||MDX expression that returns a member.|
PreviousPeriods returns optimized set of previous periods that can be used to aggregate some measure value for all previous time periods.
PreviousPeriods( [Time]..[Q2 2015].[Jun 2015].[Jun 03 2015] ) will return a set:
which is all years until previous year (in this example Time dimension starts with year
2014), all current year quarters until previous quarter (in this example
Q1 2015), all current quarter months until the previous month (
Apr 2015 and
May 2015) and all current month days until the previous day (
Jun 01 2015 and
Jun 02 2015).
The following formula can be used to calculate a cumulative sum of resolved issues until the previous period:
If we want to calculate a cumulative sum of resolved issues including the current period then we need to add the current period to the previous periods set: