4 weeks moving average for Month-Week combination?

Hi,

Thanks for the response. Actually the table I'm working on is created with Dax (summarize), so I cannot do anything on it in Power Query.

Also, as per the solution you had posted, I'm not sure if that will add month variable along with 4 weeks variable to calculate moving average.

Hi, ar-data 

If I understand correctly, you need to average 4 consecutive items in the table according to the order in the table above. If there is an index column here, then calculate the average of 4 consecutive index items.
But since you can't create an index column using PowerQuery, then we can create a ranking column based on the date.

Remove the comment and create a ranking column with your date column.

Rank = 
RANKX('Table',[Index],,ASC,Dense)
// RANKX('Table',[yourDateColumn],,ASC,Dense)

Then the Avg measure:

AVG = 
var _t=    
FILTER(
        ALL('Table'),
        'Table'[Rank]<=MAX('Table'[Rank])&&
        'Table'[Rank]>MAX('Table'[Rank])-4
        )
var _avg=IF(COUNTROWS(_t)=4,AVERAGEX(_t,[Score]))

return _avg

Result:

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

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