Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Sunny,
It is showing abrupt data at different data points. No its still not calculating MAT
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:
Additionally, by using DateDiff (difference between the two dates), you might create different flags for flagging current 3months, 6months, 1Year, Ytd, etc.
Regards,
Oktay