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?
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