In what order are nested conditions evaluated?

[Anonymous]

Hello

First, I would like to say that the DAX limit of AND/OR functions to accept only two conditions, while Excel accepts unlimited conditions, is extremely inconvenient. Is there a fix for this? Nesting conditions makes the whole expression very complex.

Secondly, in what order are nested conditions evaluated? I had the impression that they are evaluated from left to right, e.g.:

IF(condition1,IF(condition2,do1,do2)) = I thought that condition1 is evaluated first and then condition2.

Is this the case? Because I read 'If a DAX calculation is nested, theinnermost function is evaluated first.' which is very confusing.

Thanks!

[Anonymous]

Hi @Anonymous ,

For the first question, you can use "&&" / "||" instead.

AND(AND(AND(OR(OR(OR(1=1,2=2),3=3),4=4),5=5),6=6),7=7)

(1=1||2=2||3=3||4=4)&&5=5&&6=6&&7=7

For the second question, logic of IF() function is from left to right and logic of AND() / OR() function is from inside to outside.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

First The first if the condition will be evaluated, 

TRUE - Condition is true will process

False - Condition is true will process

https://docs.microsoft.com/en-us/dax/if-function-dax

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Stachu]

Regarding your first question - you can use multiple conditions with && for AND and || for OR, e.g.

(true && true && false)

  returns false

(false || true || false)

returns true 

to my knowledge your intuition regarding the order of conditions evaluations is correct

the statement about the inner calculation being evalauted first is also true, but it refers to the filter context, which is very different from conditions, see more detailed explanation here:

https://www.sqlbi.com/articles/order-of-evaluation-in-calculate-parameters/

[parry2k · Accepted solution]

@Anonymous first thing first, for multiple AND and OR , you can use && for AND and || for OR

IF (  x = 1 && y = 2 &&  z = 3 && p = "x", "abc", "xyz" )

IF (  x = 1 || y = 2 || z = 3 || p = "x", "abc", "xyz" )

on 2nd question, left to right, condition1 and then condition 2

Would appreciate Kudos 🙂 if my solution helped.