Forum Discussion
PowerBi Matrix how to handle multiple months and values
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.
1 Reply
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.
