Use Epic Target End When Story Target End is Empty

Questions & Answers
2

Hi @MichaelW,

The issues inherit the date property value, but the date-based measures, like “Issues with target end” and “Story Points with target end”, don’t. To retrieve the date from the parent of the “Story” level, I recommend the following calculated measure formula:

Sum(
  Filter(
    Descendants([Issue.Advanced Roadmaps].CurrentMember,[Issue.Advanced Roadmaps].[Story]),
    DateInPeriod(
      CoalesceEmpty(
        [Issue].CurrentHierarchyMember.Get('Target end'),
        [Issue].CurrentHierarchyMember.Parent.Get('Target end')
      ),
      [Time].CurrentHierarchyMember
    )
  ),
  ([Measures].[Story Points created],
  [Time].CurrentHierarchy.DefaultMember)
)

This formula will look through “Story” level issues of the “Advanced Roadmaps” hierarchy and replace the empty Story “Target end” date with its parent “Target end”. Otherwise, it will use the Stories date. I recommend summing the “Story Points created” instead of “Story Points with target end” as that will include Stories and their point without the “Target end” date.

To accumulate the values, you would need to use the calculated measure above in a new calculation with PreviousPeriods().

Best,
Roberts // support@eazybi.com