topic Re: IF condition multiple in DAX Commands and Tips

IF condition multiple

Vanessa250919 — Thu, 16 Sep 2021 14:07:43 GMT

Hello COmmunity,

I try to used IF with multiple condition but does't worked ...

AmountPrime = IF([Med%]>1.15,"5€", [Med%] >1.2,"20€")

I need MED% < 115% = NOT

MED%>= 115% = 5€

MED% >120% = 10€

It's possible ?

Re: IF condition multiple

BeaBF — Thu, 16 Sep 2021 15:33:30 GMT

You need to create a concatenation of IF conditions, as follows:

IF(Table[MED] < 1.15, "NOT", IF(Table[MED] >= 1.15 || Table[MED] < 1.20, "5 euro", IF(Table[MED] > 1.20, "10 euro", BLANK())))

is that what you wanted?

Re: IF condition multiple

Vanessa250919 — Thu, 16 Sep 2021 18:37:45 GMT

BeaBF Yes it's that but I a big isssue if I make a formule with < it's not ok and > it's ok check my printscreen

I don't know why ... it's same with SWITCH(TRUE

Re: IF condition multiple

BeaBF — Fri, 17 Sep 2021 07:19:32 GMT

Try this formula, where the first condition makes you avoid considering blanks:

IF(ISBLANK(Tabella[Med%]), BLANK(), IF( Tabella[Med%] < 1.15, "NOT", IF(Tabella[Med%] >= 1.15 || Tabella[Med%] < 1.20, "5 euro", IF(Tabella[Med%] > 1.20, "10 euro", BLANK()))))

It works?