Calculated measure with backdated date field (JIRA)

[shaakunthala]

So far, I managed to get it resolved with the help of the following question/answer:

Count issue with a date measure is minor that date row

Hi, I try to obtein the number of issues when the value “fecha de entrega” is minor that de date´s row. [image] I created a new measure like this, but doesn´t work. NonZero( Count( Filter( Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]), Not IsEmpty([Measures].[Issue Fecha de entrega]) --custom field imported as property and filter AND [Measures].[Issue Fecha de entrega] <= [Time].DefaultMember --numeric measure for filter ) ) ) Which is the error? Thanks! BR

[Measures].[Carried forward] = 

NonZero(
  Count(
    Filter(
      Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
      NOT IsEmpty([Issue].CurrentHierarchyMember.get('Received Date'))
      AND DateCompare(
        [Issue].CurrentHierarchyMember.get('Received Date'),
        [Time].CurrentHierarchyMember.StartDate
      ) <= 0
	  AND NOT IsEmpty([Issue].CurrentHierarchyMember.get('Submission Date'))
	  AND DateCompare(
		[Issue].CurrentHierarchyMember.get('Submission Date'),
		[Time].CurrentHierarchyMember.StartDate
	  ) > 0
    )
  )
)

Notes:

• I could not use [Measures].[Issue Received Date] property directly becuase I have formatted it in ISO date format.
• Understandably in my case, we also have a field named Submission Date. The case was corrected as “Number of issues where Received Date is prior the current quarter, but submitted during the current quarter or in the future”. In Progress status was not taken into account.

Thanks to @jlopmor and eazyBI staff @ilze.leite for the answer in the mentioned thread.

Regards,
Shaaku