Forum Discussion

Thiago's avatar
Thiago
Regular Visitor
10 years ago
Solved

Sum hours

Hello everyone!   I need to get the sum of hours in a given field and I know that the total sum that exceeds 24 hours .   I've tried using the code below , but it didn't work: Column = (LEFT([H...
  • AlexChen's avatar
    AlexChen
    10 years ago

    Hi, 

     

    For example, you have a table like below, the “time” column is date type:

     

     

    You can create a measure :

     

    Measure = sumx('table', hour('table'[time])) + TRUNC(sumx('table', MINUTE('table'[time]))/60)  & ":" & mod(sumx('table', MINUTE('table'[time])), 60) & ":00"

     

    The result is what you want:

     

     

     

     

     

AlexChen's avatar
AlexChen
Microsoft Employee
10 years ago

Hi, 

 

For example, you have a table like below, the “time” column is date type:

 

 

You can create a measure :

 

Measure = sumx('table', hour('table'[time])) + TRUNC(sumx('table', MINUTE('table'[time]))/60)  & ":" & mod(sumx('table', MINUTE('table'[time])), 60) & ":00"

 

The result is what you want:

 

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for the solution. It worked fine for me, but I had to make a minor adjustment:

When it resulted rounded hours, the minutes showed up without a leading zero, such as "15:0:00", hence I adjusted it as below.

Duration =
sumx('table', hour('table'[time])) + TRUNC(sumx(Base_Pautas; MINUTE(Base_Pautas[Duração Real]))/60)  & ":" &
 mod(sumx('table', MINUTE('table'[time])); 60) &
 IF(len(mod(sumx(Base_Pautas; MINUTE('table', MINUTE('table'[time])); 60))>1;":00";"0:00")