Calculating a sprint with added story points 2 days after the sprint starts

Hi,

Our sprint starts typically on a wednesday, but when holidays occur we capture the new stories added using the measure sprint story points added, there has been an agreement that we shouldn’t capture them there but 2 days after the sprint start.

Is there a way to create a user defined calculated member which will only capture story points added after this 2 day period? we have already created a user defined measure which captures story points committed during the 2 day period.

(
[Measures].[Story Points history],
[Time].CurrentHierarchy.Levels(‘Day’).DateMember(
DateAddDays(
[Sprint].CurrentMember.get(‘Start date’),2
)
)
)

Hi @jtrotman

Welcome to eazyBI community.
The direction is quite similar to your suggested example.
It can be calculated using tuples construct.
Only this time you would aggregate all time periods from the 3rd date of the sprint until the last date of the sprint

Try this tuple for your calculated measure:

Aggregate(
  { --set starts here
  --3rd date of the sprint
  [Time].CurrentHierarchy.Levels('Day').DateMember(
    DateAddDays(
      [Sprint].CurrentMember.get('Start date'),2
    )
  ):
  --last date of the sprint
  [Time].CurrentHierarchy.Levels('Day').DateMember(
      [Sprint].CurrentMember.get('End date')
   )
  }, --set ends here
  [Measures].[Sprint story points added] --numerical measure for calculation 
)

Martins / eazyBI

Thanks very much, seems to have done the job.

Jeff