5 Day Average per week

[damit23183]

Hi,

I am looking for solution to get  5 day average per week.

I have table like this;

I would like to see result like this;

As you can see I would like to see 5 day average from current week to last 5 weeks.

I have tried some solution but not working as expected.

Any help would be appreciated!

Thanks

[ThxAlot]

avg5.pbix

A typical senario where WINDOW() function comes into play.

[ryan_mayu]

@damit23183 

you can try to create an index column and use DAX to create another column

Column = 
VAR _max=max('Table'[Index])
return if ('Table'[Index]+4>_max,blank(),AVERAGEX(FILTER('Table','Table'[Index]>=EARLIER('Table'[Index])&&'Table'[Index]<=(EARLIER('Table'[Index])+4)),'Table'[total]))

pls see the attachment below