4wk moving average per group

Hi ZubinB

Assuming that the four weeks can cross between two years, you will need a separate weeks table that has a column of the weeks' chronological order as you can't simply subtract 3 from the current week. Assuming also that there are only 52 weeks in a year, create this calculated table and relate it to your fact.

Weeks = 
VAR _Weeks =
    SELECTCOLUMNS ( GENERATESERIES ( 1, 52, 1 ), "Week", [Value] )
VAR _year =
    SELECTCOLUMNS ( { 2024, 2025 }, "Year", [Value] )
VAR _crossjoined =
    ADDCOLUMNS (
        CROSSJOIN ( _year, _Weeks ),
        "YYWW", VALUE ( RIGHT ( [Year], 2 ) & FORMAT ( [Week], "00" ) )
    )
RETURN
    ADDCOLUMNS (
        _crossjoined,
        "Order", RANKX ( _crossjoined, [YYWW],, asc, DENSE )
    )

Create this measure:

4 WMA = 
VAR _period =
    FILTER (
        ALL ( Weeks ),
        Weeks[Order]
            >= MAX ( Weeks[Order] ) - 3
            && Weeks[Order] <= MAX ( Weeks[Order] )
    )
VAR _AVG =
    AVERAGEX ( _period, CALCULATE ( SUM ( 'Table'[Value] ) ) )
RETURN
    _AVG

Please see the attached sample pbix.

If this isn't what you're looking for, please provide more details as we'll just end up with assumptions.

Hi ZubinB ,

Can you check with below DAX function

4WMA =
VAR CurrentWeek = SELECTEDVALUE('Table'[YYWW]) -- To Get current YYWW
VAR CurrentPlatform = SELECTEDVALUE('Table'[Platform]) -- To Get current Platform

RETURN
CALCULATE(
AVERAGE('Table'[Value]),
FILTER(
ALL('Table'),
'Table'[Platform] = CurrentPlatform &&
'Table'[YYWW] <= CurrentWeek &&
'Table'[YYWW] > CurrentWeek - 4
)
)

Hi Abhilash_P  

Thank you for taking the time in answering the question.

It didn't return any error but it dint give any numbers. it created 4WMA column with blanks.

what am i doing wrong? sorry im a beginner in powerbi..

Thanks

Hi ZubinB please try this