Average of 4 weeks Data

[happy16_2023]

I want to get the average of 4 weeks data in DAX. can someone help on this?

[v-jianboli-msft · Accepted solution]

Hi @happy16_2023 ,

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

Please try:

Measure =
CALCULATE (
    AVERAGE ( 'Table'[Value] ),
    FILTER (
        ALL ( 'Table' ),
        WEEKNUM ( 'Table'[Date] ) <= WEEKNUM ( MAX ( 'Table'[Date] ) )
            && WEEKNUM ( 'Table'[Date] )
                >= WEEKNUM ( MAX ( 'Table'[Date] ) ) - 3
    )
)

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.

[Greg_Deckler]

@happy16_2023 Rolling Weeks - Microsoft Power BI Community