Forum Discussion
Duration aggregates
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 🙂
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-Date/td-p/1424191?
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
4 Replies
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
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.
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-Date/td-p/1424191?
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
