Forum Discussion

kotlonarendra's avatar
kotlonarendra
Frequent Visitor
4 years ago
Solved

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

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,34...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • rajulshah's avatar
    rajulshah
    4 years ago

    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.

rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
4 years ago

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's avatar
    kotlonarendra
    Frequent Visitor
    4 years ago

    Thanks, your solution worked.

    Regards,

    Naren