PowerBi Matrix how to handle multiple months and values

[fazza1991]

Hi

I am trying to work out the best way to create a matrix table to handle Multiple months with revenue per month. Also i want it to show the avg. of the last 6 months but as a standalone column not broken down by the months 

This is what keeps happening i want it to kind of show like this 

Any help would be appreciated.

[FreemanZ]

hi @fazza1991 ,

you can try anyone of these:

1) plot with a rolling 6m average measure

2) plot a new visual for the 6m average measure and carefully make it like part of the monthly visual.

3) write a measure for every month, if it does change often. You may also name them as current month, previous month, preprevious month, etc.