Forum Discussion

damit23183's avatar
damit23183
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

5 Day Average per week

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

Need Help

2 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    3 years ago

    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