Min Start date of Epic based on Issues Sprint earliest start date

Hi,

Please, how can I set the min start date to my Epic (and upper levels) returned by the below measure that retrieves the earliest sprint date issues in Epic?

Order(
    [Sprint].[Sprint].getMembersByKeys(
      [Issue].CurrentHierarchyMember.get('Sprint IDs')
  ),
  [Sprint].CurrentHierarchyMember.Get('Start date'),
  BASC
).item(0).Get('Start date')

Hi MikeS,
Thank you for reaching out!

Let’s name your formula [Min start sprint date].
You can use the following formula to show Min of those sprint dates for epics or other upper levels.

TimestampToDate(Min(
Filter(
DescendantsSet([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issues created]>0
),
DateToTimestamp([Measures].[Min start sprint date])
))

If you use the Time dimension in the report, issues will be filtered by issue creation dates because [Measures].[Issues created] is used. You can change the measure if you want different grouping by time.

Best,
Ilze