Excluding issues using last updated date

Questions & Answers
1

I have this report that is counting the number of Epics in Status at the start of the PI. The members in time are just a date: [Time].[Day].DateMember(‘May 08 2024’). I would like to exclude Epics from the count that have not been updated within the last 6 months.

image
image1403×590 39.7 KB

2

Hello @Seth44 ,

To exclude Epics that haven’t been updated within the last 6 months from your count, you can use a calculated measure with the following formula:

Sum(
  Filter(
    -- Get all issues in the current hierarchy context
    DescendantsSet(
      [Issue].CurrentHierarchyMember, [Issue].[Issue]
    ),
    -- Filter for issues updated within the last 6 months
    DateCompare(
      [Issue].CurrentHierarchyMember.Get('Updated at'), 
      DateAdd('m', -6, DateParse('today')) 
    ) > 0
  ),
  -- Sum the Issues history measure for filtered issues
  [Measures].[Issues history]
)

Kindly,
Gerda // support@eazybi.com