Forum Discussion
Error in Comparing Date/Time Columns
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.
Community ChampionThe image link is broken!
Yeah, it is not working for some reason. Can you try the google drive link for the same image?
- tex628
TIME() 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! - tex628
Honestly, if you just use TIME() on your intime column i think it should work :)
I could not understand it.
Time(,,) is supposed to convert the parameters to a time format. But the In Time column is already in a time format. I need to compare it to my custom Times.
tex628 wrote:Honestly, if you just use TIME() on your intime column i think it should work :)
- tex628
I know it looks weird but TIME() converts to datetime -> 1899-01-01 12:01:01.
Try and use it as a measure in a card and watch what it produces!