Duration aggregates

[LenkaH]

Hello, I am fairly new to PBI so I would like to have your advice on this my issue.

I have the table where in a column are seconds in number format. I will need to work with this in visuals and I will need it to be shown as hh:mm:ss format.
I will also use time slicer so I need it to aggregate properly. I tried to solve this but the closest thing I got to was it showing in h:nn:ss format. This doesn't work for me because I have sums bigger then 24 hours. For example it showed for one user (one row) duration of 13:06:15 instead of 37:06:15.

Hope I described my problem properly. Thank you for any advice 🙂

[LenkaH]

I tried all your suggestions and it works for translating seconds to correct format. However the aggregating doesn't work for me. Perhaps the problem is in the text format of the calculated column?

I have table like this:

User	Day	Duration [s]
User 1	01.09.2020	450
User 2	01.09.2020	4860
User 1	02.09.2020	6800
...

In the final report I need visuals that will use time slicer for aggregating data per users.

When I tried your suggestions it did not aggregate the data. The table in visual shows separete rows for each day in time slicer. 

[v-deddai1-msft · Accepted solution]

Hi @LenkaH ,

Would you please refer to my answer in https://community.powerbi.com/t5/Desktop/Date-Time-Decimal-number-number-of-hours-to-get-result-in-D...

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@LenkaH , refer if these can help

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-i...

[Pragati11]

Hi @LenkaH ,

How are you trying to convert seconds to hh:mm:ss???

There are few existing threads for this on the community:

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

Thanks,

Pragati