Count issues when complete date is after 2019-12-31

Questions & Answers
1

How do I count issues that have “Complete Date” field value after 2019-12-31?

I tried with following formula but got this error:
Formula is not valid:
No function matches signature ‘.get(, )’

Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    ([Measures].[Issues created],
    DateCompare([Issue].CurrentMember.get("Complete Date","2019-12-21")=1))),
([Measures].[Issues created],
  [Label].[Niche]))
2

Hi @Sarath,

There is a syntax error in the get function - you should close it after the “Complete Date” :

...
DateCompare([Issue].CurrentMember.get("Complete Date"),"2019-12-21")=1
...

Still, I would suggest the following formula that might be faster to get the count of issues with a Complete date after the specified date. This would subtract from all issues with the complete date the ones that have a complete date before the specified day.

NonZero([Measures].[Issues with due date] -
Sum(
  PreviousPeriods(
    [Time].[Day].DateMember(DateParse("2019-12-21"))
  ), [Measures].[Issues with due date]))
)

Lauma / support@eazybi.com

1 Like