DAX error message

Question

Hi everyone,&nbsp;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 it says it is missing a syntax but doesn't tell me where unfortunately.&nbsp;SLA Met = IF(AND([State Open] = "0", [Incident Type] = "Incident", [Work Time Duration Formatted] &gt;3), "Yes", IF(AND([State Open] = "0", [Incident Type] = "Service Request"), "NO", "Open"))&nbsp;Am I not able to have 3 conditions for my first section? I intend to add a 3rd condition to the 2nd result also but want to nail this one to begin with.&nbsp;Effetively in the end I want to build it up so that the results show&nbsp;as below:&nbsp;State Open &nbsp; &nbsp;Incident Type &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Work Time Duration Formatted &nbsp; &nbsp;Result0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Incident &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&gt;3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Miss0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Incident &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&lt;=3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Hit0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Service Request &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &gt;5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Miss0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Service Request &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;=5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Hit&nbsp;Anything else would be "Open"&nbsp;Thanks so much if anyone is able to assist, hopefully it's an easier one?&nbsp;&nbsp;&nbsp;

marcorusso · Accepted Answer

The AND function has only two arguments, use the &amp;&amp; operator instead so it's easier to write.SLA Met =
IF (
    [State Open] = "0"
        &amp;&amp; [Incident Type] = "Incident"
        &amp;&amp; [Work Time Duration Formatted] &gt; 3,
    "Yes",
    IF ( [State Open] = "0" &amp;&amp; [Incident Type] = "Service Request", "NO", "Open" )
)

Forum Discussion

DAX error message

2 Replies

Related content

error message

Error message : Expression.Error

Error message on notebook sql

WebView2 error message

Power BI Error Message