Epic's Latest Due Date based on Child Tickets

Questions & Answers
2

Hi @matt,

You are on the right track by using the Max() and Descendants() functions. The only improvement I can think of is using the Issue dimension “Epic” hierarchy within the Descendants(). See an example below:

TimestampToDate(
  Max(
    Filter(
      Descendants([Issue.Epic].CurrentMember),
      [Measures].[Issues with due date]>0
    ),
  DateToTimestamp([Measures].[Issue due date])
  )
)

If you don’t intend to look at a specific issue level, you can omit the level part of the Descendants() function. Also, you can reduce the set of issues retrieved with the Filter() function by using the measure “Issues with due date” instead of “Issues created”.

Best,
Roberts // support@eazybi.com

1 Like