I would like to adjust the number of "Issues resolved" based on the "Issues created" issue

Hello
I would like to adjust the number of “Issues resolved” based on the “Issues created” issue.

Therefore, I would like to make the issue created in January as if it were closed in January even if it was closed in February.

Can you make this possible?

image

Hi,

This use case would require a custom measure with the following formula.

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  DateInPeriod(
    [Measures].[Issue created date],
    [Time].CurrentHierarchyMember
  )
  AND
  ([Measures].[Issues resolved],
   [Time].CurrentHierarchy.DefaultMember)>0
  )
))

Kindly,
Janis, eazyBI support