Forum Discussion

sureshsonti's avatar
sureshsonti
Helper II
9 years ago

Sum hours

Need Help with calculating sum of hours. 

 

I have employee times IN & OUT and also the hours. But I can not calculate or sum their hours. The IN & OUT are set as HH:MM and I created a measure for HOURS and it is also set as HH:MM. 

 

 

 

 

 

Need Help

2 Replies

  • Reid_Havens's avatar
    Reid_Havens
    Most Valuable Professional
    9 years ago

    Hi there,

     

    Happy to help! User Greg_Deckler actually posted a great solution to this here. Which uses a combination of DAX Columns & Measures to calculate the total you're looking for. If you still need help I'm happy to assist further.

     

    Reid Havens - Principal Consultant

    PowerPivotPro

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi sureshsonti,

     

    In addition to the solution provided by Reid_Havens above, here is an idea about adding support for "duration" data type in the report view as in Power Query. You can vote it up and add your comments there to improve Power BI on this feature. :smileyhappy:

     

    Regards