Forum Discussion
Error in Comparing Date/Time Columns
Can anyone help me with this weird issue that I am facing? I am trying to define the shift of a person using his In Time data. But the measure classifies a few time instants incorrectly. ...
Yes, your 'InTime' column is currently time format -> 10:01:01
When you use the TIME() function you will return datetime format -> 1899-01-01 10:01:01If you create a new column, converting the values that you have in your 'InTime' column using TIME() you should get the same timestamps but in datetime and with 1899-01-01 as the Y/M/D
Use that column instead of the 'InTime' column and the original expression should work.
Yeah, it is not working for some reason. Can you try the google drive link for the same image?
tex628
Community Champion
Community ChampionTIME() Dax syntax converts to datetime:
So your intime column which only consists of a few hours will always be <1 when compared in the measure!