Unable to perform conditional comparisons between tow decimal values from two different columns

[kotlonarendra]

I have a table which has list of windows OS version (data type is decimal)
osVersiondetailed

osVersiondetailed
20,348.1503
20,348.1535
20,348.1450
20,348.1432
20,348.1447
20,348.1432
20,348.1442
20,348.1450
20,348.1450
20,348.1501
20,348.1450
20,348.1501
20,348.1501
20,348.1440
20,348.1501
20,348.1450
20,348.1450
20,348.1450
20,348.1432
20,348.1501
20,348.1442
20,348.1503
20,348.1450
20,348.1450
20,348.1503
19,041.1178
20,348.1503
20,348.1450
19,041.1183
20,348.1450
20,348.1503
20,348.1450
20,348.1450
20,348.1503
20,348.1018
19,041.1176

There is another table which has the details of minimum version
detailedVersion

detailedVersion

20,348.15

Tried creating a new columns in the first table which has DAX query to compare each of the entries in osVersiondetailed with detailedVersion and return true if version above the detailedVersion and false if version below detailedVersion
query:

onLatestOSVersionv1 = IF('IntuneHoloLensDevices'[osVersiondetailed] >= RELATED(latestOSVersion[detailedVersion]), True, False)


it return True in all cases.
please let me know where am I doing wrong

[rajulshah · Accepted solution]

Hello @kotlonarendra ,

Please try the below formula:

onLatestOSVersionv1 = 
VAR LookupLastestVersion = MINX(VALUES(latestOSVersion[detailedVersion]),latestOSVersion[detailedVersion])
RETURN
  IF('IntuneHoloLensDevices'[osVersiondetailed] >= LookupLastestVersion, TRUE(), FALSE())

Please let me know if this doesn't work.

[kotlonarendra]

Thanks, your solution worked.

Regards,

Naren