Forum Discussion
Calculating Average Hours Worked/Week by Week, Month, Year
Hey everyone, I believe this should be a fairly straight forward question, so let's give it a shot! I have a very simple database that tracks daily employee hours worked (see below for a small sample...
Hi Anonymous
when you select "january", the number of total weeks is 5, but you need the "Average Hours Worked/Week" =
Sum Hours Worked(1/1~1/31), Divided by Count of Employees, Divide by Count of Total Weeks(4),
Right?
Or the number of weeks for "january" =4+4/7
Best Regards
Maggie
Hi Maggie,
v-juanli-msft wrote:when you select "january", the number of total weeks is 5, but you need the "Average Hours Worked/Week" =
Sum Hours Worked(1/1~1/31), Divided by Count of Employees, Divide by Count of Total Weeks(4),
Right?
Yes, that is correct. I know this is not strictly a PowerBI question, and more of a general analytical one, but I am just having difficulty with understanding how to do this kind of calculation.
Thank you,
Mike