Count distinct dates greater than a given date

[jakobjensen]

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"

[tresesco · Accepted solution]

Try like:

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