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

**URL:** <https://community.eazybi.com/t/roll-up-sprint-start-and-end-dates-from-stories-to-epic-on-gantt-chart/11418>\
**Category:** Questions & Answers\
**Tags:** gantt-chart\
**Created:** [January 6, 2023, 10:25pm UTC](https://community.eazybi.com/t/roll-up-sprint-start-and-end-dates-from-stories-to-epic-on-gantt-chart/11418 "2023-01-06T22:25:55Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![janis.plume](https://community.eazybi.com/user_avatar/community.eazybi.com/janis.plume/32/8826_2.png) [@janis.plume](https://community.eazybi.com/u/janis.plume)\
**Post date:** [January 13, 2023, 3:36pm UTC](https://community.eazybi.com/t/roll-up-sprint-start-and-end-dates-from-stories-to-epic-on-gantt-chart/11418/2 "2023-01-13T15:36:11Z")

</div>

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:

```auto
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:

```auto
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

---

_[View the full topic](https://community.eazybi.com/t/roll-up-sprint-start-and-end-dates-from-stories-to-epic-on-gantt-chart/11418)._