Resolved date based on the created date

Questions & Answers
2

Hi @McKogan,
Welcome to the eazyBI community! :wave:

You can adjust your first formula, so it is grouped on Time dimension by the created date:

    NonZero(
  sum(
    Filter(
      Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
    Not IsEmpty([Measures].[Issue closed date])
    AND
    DateDiffDays(
      [Measures].[Issue created date],
      [Measures].[Issue closed date]
    ) <= 15 ),
    [Measures].[Issues created]
  )
)

Then the same grouping is used for your second formula:

image
image1012×1184 107 KB

With this, you should be able to avoid weird results, but let me know if you still encounter some problems!

best,
Gerda