topic Average of 4 weeks Data in DAX Commands and Tips

Average of 4 weeks Data

happy16_2023 — Wed, 26 Oct 2022 14:56:53 GMT

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

Re: Average of 4 weeks Data

Greg_Deckler — Wed, 26 Oct 2022 15:02:15 GMT

happy16_2023 Rolling Weeks - Microsoft Power BI Community

Re: Average of 4 weeks Data

v-jianboli-msft — Mon, 31 Oct 2022 06:05:07 GMT

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.