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,
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,
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
)
)