power bi sum hours as duration code example
Example: power bi sum hours as duration
Duration =
sumx('Individual Times', hour('Individual Times'[Time])) + TRUNC(sumx('Individual Times', MINUTE('Individual Times'[Time]))/60) & ":" &
mod(sumx('Individual Times', MINUTE('Individual Times'[Time])), 60) &
IF(len(mod(sumx('Individual Times',MINUTE('Individual Times'[Time])), 60)) > 1,":00","0:00")