Forum Discussion

JordanJackson's avatar
JordanJackson
Icon for Advocate II rankAdvocate II
3 years ago
Solved

Unexpected results with DAX Measure

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 th...
Need Help
  • AntonioM's avatar
    AntonioM
    3 years ago

    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.

AntonioM's avatar
AntonioM
Icon for Solution Sage rankSolution Sage
3 years ago

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's avatar
JordanJackson
Icon for Advocate II rankAdvocate II
3 years ago

That has worked perfectly, Thankyou!