Forum Discussion
Calculating Weeks With Hours Worked
Hello - I need to calculate the number of weeks Employees have worked either regular or overtime hours. I have two tables - The first I'll call EmployeeData with distinct employee IDs and other relative data, and another I'll call EmployeeHours which is a table that records the daily number of hours containing Employee IDs, Full Date, Week Of Year, Regular Hours, Overtimehours. I need to put the total number of weeks worked into the table with distinct employee IDs. I cannot just count distinct WeekOfYear because sometimes the values of hours worked is 0.
I'm trying to do a calculated column in the EmployeeData table but it's not working:
CALCULATE(
DISTINCTCOUNT('EmployeeHours'[WeekOfYear]),
SUM('EmployeeHours'[OTHours]) > 0) ||
SUM('EmployeeHours'[RegularHours>0))
2 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi, nbarta
May I ask if your problem is solved? If not resolved, can you provide sample data and your expected output? This will better describe your problem. How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
