Showing count based on date comparision

Questions & Answers
1

image

I want to show total , number of rows where due date <= Planned released date, number of rows due date > planned released date.

9 - 6 - 3 is what I want to achieve in report.
Total number is straight forward,

2

DateCompare function is your companion
Because if you want to have “due date <= Planned release” it will return either 0 or 1.


Count( 
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    [Issue].CurrentHierarchyMember.get('Status') = "Released" AND
    DateCompare(
      [Issue].[Due Date],
      [Issue].[Planned Release Date]
    ) <=0
  )
)

And for case of “due date > planned released date”


Count( 
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    [Issue].CurrentHierarchyMember.get('Status') = "Released" AND
    DateCompare(
      [Issue].[Due Date],
      [Issue].[Planned Release Date]
    ) >0
  )
)
3

I am not getting required count. Getting 0 for both.

I tried changing as below and get mmm dd yyyy printed

image
image195×501 2.11 KB

Count(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
DateCompare(
[Measures].[Issue due date],
[Measures].[Issue Planned Release Date]
) >0
)
)