Rolling 3 Month Average Help QUICK

Hi jen8080 ,

Here a potential solution:

For this to work, you need a date dimension in your model. Here a blog post on how you can achieve this:

Create a Date Dimension in Power BI in 4 Steps - Step 1: Calendar Columns - RADACAD

After that you can connect the date dimension with the [date 2] column of your table:

Finally, you can create a measure like this:

TomsRolling3Measure = 
CALCULATE (
    AVERAGE (Table11[Days between Date 1 and 2] ),
    ALL (Table11),
    DATESINPERIOD (
        'date'[Dates],
        EOMONTH ( LASTDATE ( Table11[Date 2] ), 0),
        -3,
        MONTH
    )
)

Note, the table in my model is called 'table11'.

Let me know if this solves your issue 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/