Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
Try like:
count({<[orderdate.autoCalendar.Date]={">$(=Date([orderdate.autoCalendar.Date]-365))"}>} distinct [orderdate.autoCalendar.Date])
Try like:
count({<[orderdate.autoCalendar.Date]={">$(=Date([orderdate.autoCalendar.Date]-365))"}>} distinct [orderdate.autoCalendar.Date])