Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
SebaSpotti
Helper II
Helper II

Average of worked hours per each employees

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:

Cattura4.PNG

 

 

 

 

 

 

 

 

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

Any suggestions?

 

Thank you!

2 ACCEPTED SOLUTIONS

Hi @SebaSpotti ,

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

lkalawski_0-1726048524191.png

The result in a table:

lkalawski_1-1726048536267.png

 

PBI_SuperUser_Rank@1x.pngMemorable Member | Former Super User
If I helped, please accept the solution and give kudos! 
Linkedin

 

 

View solution in original post

v-kaiyue-msft
Community Support
Community Support

Hi @SebaSpotti ,

 

You can create a Calculated column to calculate the average.

vkaiyuemsft_0-1726106482698.png


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

vkaiyuemsft_1-1726106497540.png

 

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.

View solution in original post

4 REPLIES 4
v-kaiyue-msft
Community Support
Community Support

Hi @SebaSpotti ,

 

You can create a Calculated column to calculate the average.

vkaiyuemsft_0-1726106482698.png


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

vkaiyuemsft_1-1726106497540.png

 

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
Resident Rockstar
Resident Rockstar

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:

lkalawski_0-1726047357146.png

 

 

PBI_SuperUser_Rank@1x.pngMemorable Member | Former Super User
If I helped, please accept the solution and give kudos! 
Linkedin

 

 

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"..

Hi @SebaSpotti ,

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

lkalawski_0-1726048524191.png

The result in a table:

lkalawski_1-1726048536267.png

 

PBI_SuperUser_Rank@1x.pngMemorable Member | Former Super User
If I helped, please accept the solution and give kudos! 
Linkedin

 

 

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.