
New Member

June 14, 2021

Hi Mynda,
I needed help with one of you videos (Convert Decimal Time to Days, Hours & Minutes in Power BI).
I followed every step to the dot. But it seems to have a some glitch.
As soon as the second crosses 29s, the minute increments by value of one.
Example:
Original Time | Converted Time
02 m 29 s | 02 m 29 s
02 m 30 s | 03 m 30 s
Need you insight as to why this issue is happening?


October 5, 2010

Hi Mohammed,
It looks like PBI is internally rounding up the minutes value before calculating the minutes and seconds for its durations. This is throwing off my calculations as I wouldn't expect this.
I've modified my code to replicate this behaviour so that it rounds up the decimal minutes value and then calculates the minutes and seconds.
Please see the file linked below.
Regards
Phil

Answers Post


October 5, 2010

Hi Mohammed,
That's a text column so you can't SUM it, hence the Total in the table makes no sense.
You can write a measure to calculate total wait time for each user but you'd need to specify the criteria for the calculation : do you want total wait time over a specific period? For all time? For a specific issue? Or some mixture of all of those?
Regards
Phil
1 Guest(s)
