Hour convert

[Anonymous]

Hey guys, I am using the following code to only produce hours from two different columns: hours and minutes. If the minute is over 30, then i need to round it up to the following hour. I am using the following code(below) and it works fine. However, I one of the times that I have is 24 52 minutes and it gives me a value of 1. When it should 25. Any ideas how to fix that?

Rounded Time =

VAR T = TIME('Avg By Daykrauti'[Trukmė Prastova Radviliškis Convertkrauti], 'Avg By Daykrauti'[Trukmė Prastova Radviliškis Convertkrauti 2],0) RETURN

HOUR(

IF( MINUTE(T) > 30,

MROUND(T, 1/24 ),

HOUR(T)/24

)

)

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

That is how TIME() works, please refer https://docs.microsoft.com/en-us/dax/time-function-dax

If you pass it a value of 25 for hours that will be converted to 1.

If you want to show hour values greater than 23 then don't use TIME(), just use the text value for the hours.

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[v-shex-msft · Accepted solution]

Hi @Anonymous,

I think you need to use the time function instead, hour function only used to extract the hour part from time or DateTime values.

BTW, you can also take a look at the following blog about time duration value conversion and aggregate if it helps.

Aggregating Duration Time 

Regards,

Xiaoxin Sheng

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

That is how TIME() works, please refer https://docs.microsoft.com/en-us/dax/time-function-dax

If you pass it a value of 25 for hours that will be converted to 1.

If you want to show hour values greater than 23 then don't use TIME(), just use the text value for the hours.

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

[amitchandak]

@Anonymous , not very clear.

but refer these

https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-using-dax
https://social.technet.microsoft.com/wiki/contents/articles/33644.powerbi-aggregating-durationtime-in-dax.aspx
https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?GroupId=547&MessageKey=814a2cb4-3cca-4cd1-a620-c467adeaaaf6&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer
https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389