Forum Discussion

rmartin1's avatar
rmartin1
Frequent Visitor
3 years ago

Dax formula help

Hi All, I was wonder if you can provide some help with dax formula is not working when I drop it in custom column.      Update Status = IF ( [Operating System] = "Windows 10" && [OS Version] >= ...
"DAX"
DAX Formulas
rmartin1's avatar
rmartin1
Frequent Visitor
3 years ago

my goal is

 

Column Name: Update Satus = IF [Operating System] = "Windows 10" and [OS Version] >= 2604 then "Updated"  elseif [Operating System] = "Windows 2012" and [OS Version] >= 20821 then "Updated" elseif [Operating System] = "Windows 2019" and [OS Version] >= 4010 then "Updated" else "Not Updated"

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    hi rmartin1 

    try like:

    Column = 
IF(
    ([Operating System] = "Windows 10" && [OS Version] >= 2604)
        || ([Operating System] = "Windows 2012" && [OS Version] >= 20821)
        || ([Operating System] = "Windows 2019" and [OS Version] >= 4010),
    "Updated",
    "Not Updated"
)