Answers for "power bi sum hours as duration"

0

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")
Posted by: Guest on February-12-2021

Browse Popular Code Answers by Language