Forum Discussion
Average per week
hi,
i want to calculate an average salary per week per employee.
| Name | Week | Salary |
| A | 1 | 60 |
| B | 1 | 70 |
| C | 1 | 50 |
| D | 1 | 70 |
| A | 1 | 80 |
| B | 1 | 70 |
| C | 1 | 80 |
| A | 1 | 20 |
| B | 1 | 60 |
| C | 1 | 70 |
| D | 1 | 50 |
| A | 1 | 70 |
| B | 1 | 80 |
| C | 1 | 70 |
kind regards
Hi Framboosje,
To achieve this, you can create a calculate column using DAX formula below:
Result = CALCULATE(AVERAGE(Table1[Salary]), ALLEXCEPT(Table1, Table1[Name], Table1[Week]))
Regards,
Jimmy Tao
5 Replies
It looks to me you only need a simple measure:
Average Salary = AVERAGE([Salary])
In your table chart, you add Week, Employee and Average Salary. You will see your average per week per employee.
Let me know if I missed something
Hi Framboosje,
To achieve this, you can create a calculate column using DAX formula below:
Result = CALCULATE(AVERAGE(Table1[Salary]), ALLEXCEPT(Table1, Table1[Name], Table1[Week]))
Regards,
Jimmy Tao
