Anyone have an example of a measure with a rolling date applied to it? I am struggling to create the correct expression.
I tried:
SUM(aggr(sum({$<order_type={'sale'}>} and [completed_date.autoCalendar.Date])>=num(today())-60 and floor([completed_date.autoCalendar.Date])<= num(today()),[completed_date.autoCalendar.Date]) distinct quantity), order_product_id))
but there was an error in expression.
Any help or examples of an expression will be appreciated! Thanks in advance.
