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 IIThe column is a lot easier, thank you. Would you be able to explain the measure for me a little more? I don't understand the _2 part.
Thank you