topic Re: Month to Date Measure in App Development

Month to Date Measure

Anonymous — Thu, 30 Aug 2018 20:57:11 GMT

Trying to create a measure that sums sales from Calendar month to date.

I have so far this expression:

(sum(aggr(sum(distinct{$<[completed_date.autoCalendar.Date]={">=$(=Date(max([completed_date])-30))"}>}(order_total)), order_id))

but if I am not mistaking, the value I am getting is sales from last thirty days, not "Calendar" month. Any help to transform this expression to one that will show Month to date value? Any help is appreciated. Thank you!

Re: Month to Date Measure

Lisa_P — Thu, 30 Aug 2018 23:20:42 GMT

Hi Ism,

I can see you are using the autoCalendar features. I think the two that you want to use are the InMTD flag and the MonthsAgo field in your set analysis.

[completed_date.autoCalendar.InMTD]={1} is for dates up to today's date in all months

[completed_date.autoCalendar.MonthAgo]={0} is for current month, so the two together will limit to this month

Lisa

Re: Month to Date Measure

Anonymous — Fri, 31 Aug 2018 17:30:50 GMT

Don't think I have those fields. Any other idea on how to do this?