Sum hours

[sureshsonti]

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. 

[v-ljerr-msft]

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. 

Regards

[Reid_Havens]

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