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
Anonymous
Not applicable

Nested IF Based on two cummulative conditions

Hello,

 

I have this table:

OrderCriteria 1Criteria 2
1100%BLANK Value
290%BLANK Value
385%25%
4100%100%

 

Now I want to create a Status column that basically follows the assumptions below:

- Criteria 1 threshold = 100%

- Criteria 2 threshold = 0%

- If one the above assumptions doesn't follow the threshold we should mark the line as Rejected

 

Example of my goal:

 

OrderCriteria 1Criteria 2Status
1100%BLANK ValueAccepted
290%BLANK ValueRejected
385%25%Rejected
4100%100%Rejected

 

Can you please help me?

 

I'm trying with this, but no success so far

 

PO Status = 
VAR one_ = [Criteria 1]
VAR two_ = [Criteria 2]
RETURN
IF(ISBLANK(one_) || one_ < 1,IF(two_ > 0,"Rejected","Accepted"))

 

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Anonymous 
Please try

PO Status =
VAR one_ = [Criteria 1]
VAR two_ = [Criteria 2]
RETURN
    IF ( one_ < 1 || two_ > 0, "Rejected", "Accepted" )

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

So simple and so effective. Many thanks !!

tamerj1
Super User
Super User

Hi @Anonymous 
Please try

PO Status =
VAR one_ = [Criteria 1]
VAR two_ = [Criteria 2]
RETURN
    IF ( one_ < 1 || two_ > 0, "Rejected", "Accepted" )

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.