cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
rmartin1
Frequent Visitor

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] >= 2604 ||
[Operating System] = "Windows Server 2012" && [OS Version] >= 20821 ||
[Operating System] = "Windows Server 2019" && [OS Version] >= 4010 ||
[Operating System] = "Windows Server 2016" && [OS Version] >= 5717 ||
[Operating System] = "Oracle Enterprise Linux" && [OS Version] >= 88 ||
[Operating System] = "Red Hat Enterprise Linux" && [OS Version] >= 88 ||
[Operating System] = "Fedora Linux" && [OS Version] >= 37 ||
[Operating System] = "Debian Linux" && [OS Version] >= 17,
"Updated",
IF (
[Operating System] IN {"macOS Ventura", "macOS Big Sur", "macOS Monterey"},
[Update],
"Not Updated"
)
)

 

Thanks 

3 REPLIES 3
Anis_Hussain
Frequent Visitor

@rmartin1 
Try this Dax and check

Update Status =
IF (
[Operating System] = "Windows 10" && [OS Version] >= 2604 ||
[Operating System] = "Windows Server 2012" && [OS Version] >= 20821 ||
[Operating System] = "Windows Server 2019" && [OS Version] >= 4010 ||
[Operating System] = "Windows Server 2016" && [OS Version] >= 5717 ||
[Operating System] = "Oracle Enterprise Linux" && [OS Version] >= 88 ||
[Operating System] = "Red Hat Enterprise Linux" && [OS Version] >= 88 ||
[Operating System] = "Fedora Linux" && [OS Version] >= 37 ||
[Operating System] = "Debian Linux" && [OS Version] >= 17,
"Updated",
IF (
[Operating System] IN {"macOS Ventura", "macOS Big Sur", "macOS Monterey"} &&
NOT(ISBLANK([Update])),
"Updated",
"Not Updated"
)
)

rmartin1
Frequent Visitor

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"

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"
)

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors