From a peviously defined measure returned a sum of issues, filter out all issues with a "Target End" later than xxxxx

How would one define a measure that returns the nr of issues with a Target End later than a certain date?

I’m completly lost on comparing dates using EazyBi.

I have defined a measure listing all issues in scope:

CASE WHEN [Issue].CurrentMember.Level.Name <> 'Issue' THEN
  Cache(
    NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),
      Cache([Measures].[Issues created])
    ))
    + [Measures].[Issues created]
  )
WHEN [Time].CurrentHierarchyMember IS [Time].CurrentHierarchy.DefaultMember
THEN NonZero([Measures].[Issues due])
END

Now I want a second measure that takes the result of the one above, and gives me the number of issues that have a Target End larger than the 1st of June 2023.

How would you do this? In JQL its so simple…

Hi,

The following formula counts the issues with the Target End after the 1st of June 2023:

Sum(
  Filter([Time].[Day].Members,
    DateCompare(
     [Time].CurrentHierarchyMember.StartDate,
     DateParse('Jun 01 2023')
    )>=0
  ),
  [Measures].[Issues with Terget End]
)

This formula expects that you have imported the Targed End date field with the measure option.

Kindly,

Janis, eazyBI support