How to calculate MTD

[anindya_manna]

I want to display MTD sales based on shipdate DD-MM-YYYY format.

[sunny_talwar · Accepted solution]

May be like this:

Sum({<shipdate = {"$(='>=' & Date(MonthStart(Max(shipdate)), 'DD-MM-YYYY') & '<=' & Date(Max(shipdate), 'DD-MM-YYYY'))"}>}Measure)

[anindya_manna]

Thanks