[Measures].[Multiple Sprint guideline] in a Burn-up Chart

Questions & Answers
1

How do I modify [Measures].[Multiple Sprint guideline] in the sample Active (multiple) sprints story points burn-down chart to be utilized in my soon-to-be-created Active (multiple) sprints story points burn-up chart?

Thanks in advance.

2

Hi @AWPPMT

You may use the same burn-down guideline idea. Instead of reducing the remaining time by the period already passed since the beginning of multiple sprints, you may multiply the total story points by the time already passed and divide by the total length of the period.
The adjusted measure might be as follows:


CASE WHEN
  [Measures].[Time within multiple Sprints] > 0
THEN
  -- total commited points of all selected sprints
  ([Measures].[Sprint Story Points committed],
  [Time].CurrentHierarchy.DefaultMember
  )
 *
    DateDiffWorkdays(
      DateWithoutTime([Measures].[Multiple Sprints start date]),
      [Time].CurrentHierarchyMember.NextStartDate)
   /
  DateDiffWorkdays(
    DateWithoutTime([Measures].[Multiple Sprints start date]),
    DateAddDays(DateWithoutTime([Measures].[Multiple Sprints end date]), 1)
  )
END

Best,
Ilze, support@eazybi.com