Getting today's sales and last month's today's sales

[KeithChu]

Hi experts,

I created a measure to calculate today's sales. Something like CALCULATE(SUM('Sales'[Sales Amount], FILTER('Calendar', [Date] = MAX('Sales'[Doc Date])).

Now I would like to get last month's today's sales. But I cannot use Dateadd like I did in ssrs because for whatever reason it doesn't want scalar value. Can you help me on this? Thank you.

[Phil_Seamark · Accepted solution]

Hi @KeithChu

Does this work?

 CALCULATE(SUM('Sales'[Sales Amount]), FILTER('Calendar', EDATE([Date],1) = MAX('Sales'[Doc Date])))