Forum Discussion

DeeS's avatar
DeeS
New Member
9 years ago
Solved

DAX error message

Hi everyone,   I really hope you can help, I'm completely new to PowerBI and DAX but am giving creating a new column a go in my dataset. I have the below but when I run it through a DAX checker and...
  • marcorusso's avatar
    marcorusso
    9 years ago

    The AND function has only two arguments, use the && operator instead so it's easier to write.

    SLA Met =
IF (
    [State Open] = "0"
        && [Incident Type] = "Incident"
        && [Work Time Duration Formatted] > 3,
    "Yes",
    IF ( [State Open] = "0" && [Incident Type] = "Service Request", "NO", "Open" )
)
marcorusso's avatar
marcorusso
Most Valuable Professional
9 years ago

The AND function has only two arguments, use the && operator instead so it's easier to write.

SLA Met =
IF (
    [State Open] = "0"
        && [Incident Type] = "Incident"
        && [Work Time Duration Formatted] > 3,
    "Yes",
    IF ( [State Open] = "0" && [Incident Type] = "Service Request", "NO", "Open" )
)
DeeS's avatar
DeeS
New Member
9 years ago

Thank you so sooo much marcorusso, this works perfectly!