cumulative total of average

[icturion]

Hi,

Within our organization we have a number of employees who collect daily matters. now we want to find out how much is collectively collected on average per day of the week. So as an example we want to know how much is collected on Monday by all employees on average throughout the year.

We have a table with the employees and we have a table with the number of pickups per employee per day. I also have a date kalander connected in my data model, in her are the days of the week.

Hopefully some nows a solution.

[amitchandak · Accepted solution]

Please check

https://community.powerbi.com/t5/Desktop/Calculating-Cumulative-total-of-average-using-DAX-expressio...