Forum Discussion

damit23183's avatar
damit23183
Microsoft 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 averag...
Need Help
ryan_mayu's avatar
ryan_mayu
Super 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