So I have a few measures that I would like to, I guess, merge to create a new one. Basically I have a measure that gives total of all sales based on expression:
I also have a date dimension that retrieves dates within last 60 days, with expression as follows:
if(floor([completed_date.autoCalendar.Date])>=num(today())-60 and floor([completed_date.autoCalendar.Date])<= num(today()),[completed_date.autoCalendar.Date],null())
I need to create a few of these, so any help or examples of set analysis with a time frame is appreciated. Thanks in advance.