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...
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
You can summarize that info in a new table:
AverageperEmployee =
SUMMARIZE (
'Table',
'Table'[Name],
'Table'[Week],
"Average Salary", AVERAGE ( 'Table'[Salary] )
)
Thanks but can this be done in a calculation instead of a new table?
ArentirResolver III
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
this is not gonna work for me because i need averages of 3 different things per week in one chart