topic Re: Count number of dates (including duplicates) higher than selected date in App Development

Count number of dates (including duplicates) higher than selected date

zakpullen — Wed, 22 Feb 2023 15:10:19 GMT

Hello,

I need to count the number dates (not distinct) higher than the selected date (MonthYear), i.e. how many are in the future. I've tried variations of below to no avail. I am happy that the date field formats are compatible, as I've evaluated this separately.

=Count({<[Temp.Valid Date] ={">MonthYear"}>}[Temp.Valid Date])

Many thanks

Re: Count number of dates (including duplicates) higher than selected date

BrunPierre — Wed, 22 Feb 2023 15:49:57 GMT

=Count({<[Temp.Valid Date]={">=$(=Max(MonthYear))"}>}[Temp.Valid Date])

Re: Count number of dates (including duplicates) higher than selected date

zakpullen — Wed, 22 Feb 2023 16:04:11 GMT

Thanks. It returns 0 like everything else I've tried.

Re: Count number of dates (including duplicates) higher than selected date

deepanshuSh — Wed, 22 Feb 2023 16:35:00 GMT

Since the information is not provided regarding the dates column being used here, so I would be going with the basic idea.

sum(if (dates(datecolumn)>getselectedvalue(datefieldname),1,0))

Re: Count number of dates (including duplicates) higher than selected date

rwunderlich — Thu, 23 Feb 2023 02:02:24 GMT

Is there only one possible value for MonthYear?

-Rob

Re: Count number of dates (including duplicates) higher than selected date

zakpullen — Fri, 24 Feb 2023 11:23:35 GMT

Yes, it will be the selected MonthYear. It will always be the first of that month. Both sets of dates are formatted DD/MM/YYYY.