Help with Calendar Week Numbers - No Date

Hi Anonymous ,

Based on your description, I have created a simple sample:

Please try:

Column =
VAR _a =
    AVERAGEX (
        FILTER (
            'Rolling Table',
            [Index] <= EARLIER ( 'Rolling Table'[Index] )
                && [Index]
                    > EARLIER ( 'Rolling Table'[Index] ) - 4
                && [Year] = EARLIER ( 'Rolling Table'[Year] )
        ),
        [CFS]
    )
VAR _b =
    IF (
        [Index] >= 4,
        _a,
        AVERAGEX (
            FILTER (
                'Rolling Table',
                ( [Year] * 100 + [Index] )
                    > (
                        ( EARLIER ( 'Rolling Table'[Year] ) - 1 ) * 100 + 48
                            + EARLIER ( 'Rolling Table'[Index] )
                    )
                    && ( [Year] * 100 + [Index] )
                        <= (
                            EARLIER ( 'Rolling Table'[Year] ) * 100
                                + EARLIER ( 'Rolling Table'[Index] )
                        )
            ),
            [CFS]
        )
    )
RETURN
      _b

change the format:

Output:

Then apply it to the visual:

Final output:

Best Regards,

Jianbo Li

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