Count distinct dates greater than a given date

jakobjensen — Thu, 27 Aug 2020 13:35:41 GMT

Say I want to count the number of distinct dates that have been within the last 365 days. I wrote the following meassure

count({<[orderdate.autoCalendar.Date]={">Date([orderdate.autoCalendar.Date]-365)"}>}, distinct [orderdate.autoCalendar.Date])

but that just returns "0"

Re: Count distinct dates greater than a given date

tresB — Thu, 27 Aug 2020 14:15:54 GMT

Try like:

count({<[orderdate.autoCalendar.Date]={">$(=Date([orderdate.autoCalendar.Date]-365))"}>} distinct [orderdate.autoCalendar.Date])