Forum Discussion

Anonymous

Not applicable

6 years ago

how to sum duration？

I calculated the duration, then how to sum it, get total working hour? what data type the Duration column should be? thank you

Icon for Super User rank

Super User

6 years ago

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

Related content

Sum Of Duration
5 years ago
Anonymous
sum of time duration
5 years ago
Trebor84
notebook duration time issue
1 year ago
um4ndr
Sum Duration
6 years ago
Anonymous
Sum of Duration
4 years ago
lea_313