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

[Elakiya]

I am new to Power BI. I want to find the MAT(Moving Annual Total) . I got result using below calculation in Table.

MAT (moving annual total) = CALCULATE(
SUM(TransactionData[Revenue]),
DATESINPERIOD(CalenderDate[Date],LASTDATE(CalenderDate[Date]),-1,YEAR)
)

But i want result in MATRIX format (ie) Each DATE Months are separated column. how to find it. 

Eg    Prod     Jan     Feb   Mar   

         abc       50     150   200

         efg       70        50   100

         xys       120    300   400

[Greg_Deckler]

Can you post example source data? Seems like you could put your formula in a measure versus a calculated column and achieve what you are looking for. Please try not to cross post. I have no idea if anyone has replied to your two or three other posts on this subject.

[Elakiya]

I am new to Power BI. I want to find the MAT(Moving Annual Total) . I got result using below calculation in Table Format.

MAT (moving annual total) = CALCULATE(
SUM(TransactionData[Revenue]),
DATESINPERIOD(CalenderDate[Date],LASTDATE(CalenderDate[Date]),-1,YEAR)
)

But i want result in MATRIX format (ie) Each DATE Months are separated column. how to find it. 

Eg    Prod     Jan     Feb   Mar   

         abc       50     150   200

         efg       70        50   100

         xys       120    300   400