Create a Matrix that has 3,6,12 month averages of measures

[lovekheart]

This picture showcases the end goal (sorry i dont have a better example) that i am trying to acheive. I do have a calender table and all the measures but cant seem to find how to achieve this for the matrix visual. Please reach out with any knowldege on this!

[OwenAuger]

Hi @lovekheart 

I would recommend a calculation group containing calculation items for each of the average calculations.

https://learn.microsoft.com/en-us/power-bi/transform-model/calculation-groups

Each calculation item's expression should contain SELECTEDMEASURE ( ) as a placholder for the measure it will be applied to.

For example, if your averages are defined as arithmetic means of monthly measure values for the last N months (as at the max date filtered), you might use this calculation item expression for "Last 3 months":

CALCULATE (
    AVERAGEX (
        VALUES ( 'Date'[Year Month] ), -- or column with month/year granularity
        SELECTEDMEASURE ( )
    ),
    DATESINPERIOD ( 'Date'[Date], MAX ( 'Date'[Date] ), -3, MONTH )
)

You could then construct the matrix with:

• Columns: Calculation group column
• Values: All required measures
• "Show values in rows" enabled

Is that enough to go on?

I could create a small example to demonstrate the setup if that would be useful.