Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
Solved! Go to 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! |
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.
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.
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! |
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.
The result in a table:
Memorable Member | Former Super User If I helped, please accept the solution and give kudos! |
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
109 | |
97 | |
95 | |
38 | |
36 |
User | Count |
---|---|
151 | |
125 | |
75 | |
74 | |
53 |