Sum of duration

[Noak]

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

[Greg_Deckler]

Take a look at this blog article:

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

[Noak]

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..)

[v-sihou-msft]

@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.

Regards,

[Noak]

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 .