How to work with multiple conditions in dax

[Anonymous]

Hello, 

does someone know how to select a value based on 3 or 4 conditions at the same time.

ex:

var1 = if(
           condition1 and condition2 and condition3 the do something

       if condition4 and condition 5 and condition6 then do something1

else something3)

ex: End Date=
if (isblank('var1')) && revenue > 100000 and revenue <= 500000 , value1,
if (blank(var1) && revenue >500000 , value2
else value3)

The second line (value2) work and the last line (value3) but the first value is never attribuated.

Regards,

Alain LePage

[v-eachen-msft]

Hi @Anonymous ,

I found that the condition1 is the same as condition4 in your example. Is it right?

And the value3 is in the second IF(), do you mean to get it in the first IF()?

End Date=
SWITCH (
    TRUE (),
    ISBLANK ( [var1] )
        && [revenue] > 100000
        && [revenue] <= 500000, [value1],
    ISBLANK ( [var1] )
        && [revenue] > 500000, [value2],
    [value2], [value3]
)

[Anonymous]

The first condition is revenue greater than 10000 and less or equal to 50000 while the third condition is greater than 50000

[az38 · Accepted solution]

Hi @Anonymous 

I have no idea what exactly do you nedd but it may look like

End Date=
if (isblank([var1]) && [revenue] > 100000 && [revenue] <= 500000 , [value1],
if( isblank([var1]) && [revenue] >500000, [value2], [value3]) )