Forum Discussion

Reigning_data's avatar
Reigning_data
Frequent Visitor
7 years ago

Comparing Current and Previous Moving Annual Total (MAT)

Hello All,   Context: I am trying to compare the Current MAT with Previous MAT by month. The idea being that I would have a bar, or line, graph, showing 'current MAT' as of Aug 2018 compared to 'Pr...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Reigning_data,

 

You should add [dates] from calendar table into chart X-axis. Besides, please use SAMEPERIODLASTYEAR to calculate MAT in previous year.

 

Regards,

Yuliana Gu