how to sum duration？

Anonymous , check if this can help

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx

Hi Anonymous ,

What's the format of the duration column? like hh.ms or hh:mm:ss? If the format is first one, then the data type of the duration column should be Decimal number. Otherwise, it should be Text type. You can refer the following documentions to get the sum of duration:

Power BI DATEDIFF only working days, hours and so on…

Sum a Duration

Duration Troubles

Best Regards

Rena