Average of worked hours per each employees

[SebaSpotti]

Hi all!

I have a table in which i have the worked hour for all the employees for all shifts. It's somithing like this:

How can I calculate the average worked hours per each employees?

Any suggestions?

Thank you!

[lkalawski · Accepted solution]

Hi @SebaSpotti ,

Then you can use Power Query to add the transformation and then add avg hours thresholds as conditional column. 

The result in a table:

Memorable Member | Former Super User If I helped, please accept the solution and give kudos!  Linkedin

[v-kaiyue-msft · Accepted solution]

Hi @SebaSpotti ,

You can create a Calculated column to calculate the average.

You can also directly select the pie chart visual object by dragging EmployeeID into Legend, NumWorkHours into Values and selecting Average.

More details can be found in the attachment.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[lkalawski]

Hi @SebaSpotti ,

Write a measure that calculates the average for column NumWorkHours.

AVG of NumWorkHours = AVERAGE('Table'[NumWorkHours])

Then use the table visualization, add column EmployeeID and measure average there and you will get the result:

Memorable Member | Former Super User If I helped, please accept the solution and give kudos!  Linkedin

[SebaSpotti]

I need to have the result data in a table, or in a way in which i can visualize them in pie chart with some "avg hours threesholds"..

[lkalawski · Accepted solution]

Hi @SebaSpotti ,

Then you can use Power Query to add the transformation and then add avg hours thresholds as conditional column. 

The result in a table:

Memorable Member | Former Super User If I helped, please accept the solution and give kudos!  Linkedin