comparing with date values with if condition

Question

I want to compare workers present status with time,

if any worker comes 10 mins Late then it should be like "Below 10 mins"(I tried to derive it from time diff column which I done with help of IN time & Report time )

"IF('Attendance Info'[Time Diff] <= "00:30","Below 10 mins","others")"

and the error is:

DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.

The error tells you exactly what the problem is. You're comparing a date [Time Diff] with text "00:30". They probably both should be time data types. — Alexis Olson
yeah but the time diff data type is date data type and it's format is HH:MM, when i want to change data types and am getting error records in answers. Thanks in advance — hem..

Strawberryshrub Strawberryshrub · Accepted Answer · 2019-08-30T04:39:41

A fast google search would have get you the following results:

In DAX:

Column = IF('Table'[Column1] <= TIMEVALUE("00:30");"Below10";"Others")

In M:

= if [Column1] <= Time.FromText("00:30") then "Bleow10" else "Others"

comparing with date values with if condition

1 Answers