Forum Discussion
calculate overtime
Hi All,
I am busy with a report to calculate overtime with Dax.
I have already a code that calculate the number of workhours a week
= ([TotalHoursMo] + [TotalHoursTu] +[TotalHoursWe] + [TotalHoursThu] + [TotalHoursFr] + [TotalHoursSa] + [TotalHoursSu])
So what I want is to substract 40 hours of the result of this measure IF the result greater than 40 hours.
I appreciate your help 🙂
Regards
Anonymous , something like this
measure =
var _m1=([TotalHoursMo] + [TotalHoursTu] +[TotalHoursWe] + [TotalHoursThu] + [TotalHoursFr] + [TotalHoursSa] + [TotalHoursSu])
return
if(_m1 >40, _m1-40, _m1)
2 Replies
- amitchandak
Super User
Anonymous , something like this
measure =
var _m1=([TotalHoursMo] + [TotalHoursTu] +[TotalHoursWe] + [TotalHoursThu] + [TotalHoursFr] + [TotalHoursSa] + [TotalHoursSu])
return
if(_m1 >40, _m1-40, _m1)