Forum Discussion
abeirne
Helper II
Helper IICalculating weekly overtime
Hi I am looking to calculate over time for a group of employees. I have my hours worked, a caluclated column which is DIVIDE((('Employee_Time'[Clock Out Date] - 'Employee_Time'[Clock in Date] * 1,44...
abeirne , Try a measure like
new column = datediff('Employee_Time'[Clock in Date], 'Employee_Time'[Clock Out Date],second)/3600.0new measure = sumx(addcolumns(summarize(Table, Table[Emp], Table[Week num], "_1", sum(Table[New column])), [_2], if([_1]>40, [_1]-40,blank())),[_2])
amitchandak
Super User
Super Userabeirne , Try a measure like
new column = datediff('Employee_Time'[Clock in Date], 'Employee_Time'[Clock Out Date],second)/3600.0
new measure = sumx(addcolumns(summarize(Table, Table[Emp], Table[Week num], "_1", sum(Table[New column])), [_2], if([_1]>40, [_1]-40,blank())),[_2])
abeirneHelper II
Helper III don't understand what the [_2] is supposed to be? Thanks
Measure =
Measure =
SUMX(
ADDCOLUMNS(
SUMMARIZE(
'dds Employee_Time_Tb', 'Payroll Date'[Week Num], "_1", SUM('dds Employee_Time_Tb'[Hours Worked 2])),
[_2],
IF(
[_1] > 40,
[_1] - 40,
BLANK())),
[_2]
)