calculate overtime

[Anonymous]

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

[amitchandak · Accepted solution]

@Anonymous , something like this

measure =
var _m1=([TotalHoursMo] + [TotalHoursTu] +[TotalHoursWe] + [TotalHoursThu] + [TotalHoursFr] + [TotalHoursSa] + [TotalHoursSu])
return
if(_m1 >40, _m1-40, _m1)

[Anonymous]

Yes, Thank you very much