Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Vanessa250919
Helper IV
Helper IV

IF condition multiple

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 ? 
3 REPLIES 3
BeaBF
Memorable Member
Memorable Member

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?
B.
BeaBF
Memorable Member
Memorable Member

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?
B.
 

@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

>

Vanessa250919_0-1631817413472.png

<

Vanessa250919_1-1631817435741.png

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.