How To Calculate MAT

[#1]

Hi

I have a data set in which I want to calculate MAT and I amusing this formula to calculate

Sum({<TYPE={'DATA'},XDate={'>=$(vDate) <$(vDate_1)'}>}[SALES])

Where vDate is a variable which has the value for current year date and vDate_1 has the same date of last year

but it is not showing correct value

BRs

[#2]

Hi Sunny,

It is showing abrupt data at different data points. No its still not calculating MAT

[itec_pao]

Hi all,

I have come across a solution, in order to provide a good moving annual total (MAT) analysis. The solution is called As-Of table. A very good example is provided here by Henric Conström:

The As-Of Table

Additionally, by using DateDiff (difference between the two dates), you might create different flags for flagging current 3months, 6months, 1Year, Ytd, etc.

Regards,

Oktay