Forum Discussion

Pan_Forex's avatar
Pan_Forex
Icon for Helper III rankHelper III
3 years ago
Solved

Average from every day

Hi guys! I wonder if it is possible to create a table that adds new rows every day and leaves the old ones unchanged. I have a table that is updated several times every day with new rows and a second...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Pan_Forex , try a measure with help from the date table

 

Cumm Sales = CALCULATE(AverageX(Values('Date'[Date]), CALCULATE(SUM(Table[Score]))) ,filter(all('Date'),'Date'[date] <=max('Date'[date])))

Pan_Forex's avatar
Pan_Forex
Icon for Helper III rankHelper III
3 years ago

Thank you for your reply. I would like the average to be calculated for each player separately and not all together from each day, and to create a new table with results only.