How to calculate min "Resolved at" of epic?

Questions & Answers
1

Hi! I use the formula:
TimestampToDate(
Min(
Filter(
Descendants([Issue].CurrentMember,[Issue.Epic].[Epic]),
NOT IsEmpty([Issue].CurrentHierarchyMember.get(‘Resolved at’))
),
DateToTimestamp([Issue].CurrentHierarchyMember.get(‘Resolved at’))
)
).
As a result, for every issue the minimum date is calculated for all data in the report.
How do I change the formula so that the minimum date is calculated inside each epic?

2

Hi @Elena

Sorry for the long wait!

Could you please tell me more about the intended report?

Would you like to show the Epics in the Rows and, for each Epic- the earliest resolved date of their Children?
Or would you like to show some other dimension in Rows, for example, Projects and see when the earliest Epic was resolved?

Thanks!
​Best regards,
​Nauris / eazyBI support