Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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] + [Total...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , something like this

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , something like this

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Yes, Thank you very much