How do you calculate the weekly hours for each employee?

[OCBB_SFAFPandA]

Hello,

I have a table that summarized hours by employee daily by

Total hours | Reg hrs | OT hrs | DblOT

How would I agreggate on a weekly level? and build in a calculation that if Total hours >40 in a week, any hour over is marked as OH hrs?

[Anonymous]

Hi @OCBB_SFAFPandA 

Create a calculated column or a measure depends on your requirements for data presentation . In the case of row context, calculated column can be used. If it is an aggregate operation, it is recommended to use measure. Of course, if you can provide specific data and needs, we can better help you solve the problem.

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vapid128]

add colnum 

weekNumIndex = int(([date]-2)/7)

summarize again by employee and weekNumIndex and sum hrs

[OCBB_SFAFPandA]

thanks for the reply! 

To summarize again, would these be new measures or more new columns? The end visual won't be showing emp IDs, just the location and hrs/cost on a weekly.