How to find MAT(Moving Annual Total) where Months are separate column.

[Elakiya]

I am new to POWER Bi. i want to calculate the MAT(Moving Annual Total) . I got result using below calculation in Table Fotmat.

MAT (moving annual total) = CALCULATE(
SUM(toal),
DATESINPERIOD(date_field,LASTDATE(date_field),-1,YEAR)
)

i got exact answer in above format

But  i want result in below.using the above calculation i got wrong answer in matrix format. Please any one help me to get right answer in below formatExpected output format

[v-huizhn-msft · Accepted solution]

Hi @Elakiya,

Please create a calculated column using the formula.

Month =
SWITCH (
 MONTH[Date],
 1, "January",
 2, "February",
 3, "March",
 4, "April",
 5, "May",
 6, "June",
 7, "July",
 8, "August",
 9, "September",
 10, "October",
 11, "November",
 12, "December",
 "Unknown month number"
)

Then create a matrix visual, put [Month] as Column level(highlighted in yellow) as follows, product as Row level, other measure as value level, you will get expected result.



Best Regards,
Angelia