DAX Code to round time up to the nearest Hour

[ajay_gajree]

Hi All

Can someone please give me some help in how round time up to the nearest Hour in a DAX Column?

So if the time is 00:00:01 to 00:59:59 then that should round up to 1:00:00, while 1:00:01 should round to 2:00:00

Thanks in advance!

[ajay_gajree]

That isn't quite what I need as that is rounding to the nearest hour

[ERD]

@ajay_gajree ,

You can try this:

RoundUpTime = CEILING('T'[time],"1:00")

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

[ERD]

Hi @ajay_gajree ,

There is a solution that can be found in this forum: https://community.powerbi.com/t5/Desktop/How-to-round-minutes-in-time-to-the-nearest-hour/m-p/476432 

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