Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Noak
Helper IV
Helper IV

Sum of duration

Hi guys I need your help.

By using excel work sheet as DB, I need your help with calculating duration, sumOfduration and to present in graph.

 Duration= (end time - start time) I would like to see my resulys with hh:mm.

 

ex: instaid of 1513(m) I would like to see 25:21 H

 

duration calc.png

 

BR,
Noa.
4 REPLIES 4
Greg_Deckler
Community Champion
Community Champion

Take a look at this blog article:

http://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Thank you .

I tried your solution tho , Data type is txt  - I cant sum the duration and present in graph with hh:mm.

 

Fixed_Duration = CONCATENATE([H],CONCATENATE(":",CONCATENATE([M],"")))

 

what can i do? I would like to present the axis as follows- y:sum_duration (hh:mm) x: months(jan,feb..)

BR,
Noa.

@Noak

 

In this scenario, since you already the get duration as text in HH:mm:ss format. You can go to Query Editor, convert the data type into "Duration", then you can sum it as time type.

 

Capture55.PNG

 

Regards,

It applies only to exicitng quaries from the excel workbook. not to modified columns I created in PB.

@v-sihou-msft

 

p.s I succed to convert the duration column type to duration , I cant sum it.

please help me .

 

sum.png

 

 

 

 

 

 

BR,
Noa.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.