Forum Discussion

Jeanxyz's avatar
Jeanxyz
Icon for Power Participant rankPower Participant
5 years ago
Solved

average calculation in power query

Hi,   I have a list of employee's FTE rate   (work %) by month. I would like to calculate the average FTE rate (result should look like column D) per employee in power query. how should I write the...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Jeanxyz , You might have create a table using group by avg and join it back with this table

Using group by option, Employee ID as Group and Avg of FTE rate , create a new table. Merge it back using merge option using employee id.

 

Also refer for part of the approch here

https://www.youtube.com/watch?v=EFQBMJ6JyCQ