cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
carlovsky
Helper II
Helper II

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 @carlovsky 
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
carlovsky
Helper II
Helper II

So simple and so effective. Many thanks !!

tamerj1
Super User
Super User

Hi @carlovsky 
Please try

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

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors