Average per week

[Anonymous]

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

[v-yuta-msft · Accepted solution]

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

[Anonymous]

You can summarize that info in a new table:

AverageperEmployee =
SUMMARIZE (
    'Table',
    'Table'[Name],
    'Table'[Week],
    "Average Salary", AVERAGE ( 'Table'[Salary] )
)

[Anonymous]

Thanks but  can this be done in a calculation instead of a new table?

[Arentir]

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

[Anonymous]

this is not gonna work for me because i need averages of 3 different things per week in one chart