Roll up sprint start and end dates from stories to epic on gantt chart

Questions & Answers
2

Hi,

Welcome to our community!

The dates can be found with custom calculations. Assuming that you use the Epic in the report rows, the following formula gives the date of the earliest sprint for the epic:

Head(
  Order(
  Filter([Sprint].[Sprint].Members,
    [Sprint].CurrentMember.Name<>"(no sprint)"
  AND
    [Measures].[Issues created]>0),
    [Measures].[Sprint start date],
    BASC
  )
).Item(0).Get('Start date')

The end date of the latest sprint:

Tail(
  Order(
  Filter([Sprint].[Sprint].Members,
    [Sprint].CurrentMember.Name<>"(no sprint)"
  AND
    [Measures].[Issues created]>0),
    [Measures].[Sprint start date],
    BASC
  )
).Item(0).Get('End date')

Kindly,
Janis, eazyBI support