12 Week Rolling Average without Dates

Hi richardburling ,

Based on the information you provided, for solving the problem that week 1 is the average of the first 12 weeks of the previous fiscal year, you can follow these steps:

1.Add new measure.

Measure =

AVERAGEX (

    FILTER (

        ALL ( 'Table' ),

        YEAR ( [Month Year] )

            = YEAR ( SELECTEDVALUE ( 'Table'[Month Year] ) ) - 1

            && 'Table'[Week] <= 12

    ),

    'Table'[amount]

)

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Ada Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}