Unexpected results with DAX Measure

[JordanJackson]

Hi, 

I am using a custom column in Power Query in order to +1 day to the date if the selected time column goes over midnight. 

This has worked in most cases, but not some? Evidenced in the photos attached. 

The problem seems to be from when the time is between 00:00:00 and 00:59:00?

But in the show formula it should include all from 0-7?

Any help would be greatly appreciated, thank you  . 

[AntonioM · Accepted solution]

Hi @JordanJackson ,

You might want >=0. From 00:00 to 00:59 the hour is 0 so I'm thinking the >0 condition is false there.

[JordanJackson]

That has worked perfectly, Thankyou!