Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Calculating Overtime

I've done some research within the forum to look for the same question but couldn't find it. Please let me know if I've missed it though...   Anyways, I have these 2 tables, one with work hour each...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Are you just after the amount over for each person for each week?

 

if so this might be close

 

Weekly Overtime = 
VAR 
	Overtime = SUM('Hour'[Recorded Hour])
VAR 
	ReturnValue = if(Overtime<> blank(),CALCULATE(Overtime) - 40,Blank())
RETURN 
	ReturnValue