Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    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

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

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