Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
I have this table:
Order | Criteria 1 | Criteria 2 |
1 | 100% | BLANK Value |
2 | 90% | BLANK Value |
3 | 85% | 25% |
4 | 100% | 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:
Order | Criteria 1 | Criteria 2 | Status |
1 | 100% | BLANK Value | Accepted |
2 | 90% | BLANK Value | Rejected |
3 | 85% | 25% | Rejected |
4 | 100% | 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"))
Solved! Go to Solution.
Hi @Anonymous
Please try
PO Status =
VAR one_ = [Criteria 1]
VAR two_ = [Criteria 2]
RETURN
IF ( one_ < 1 || two_ > 0, "Rejected", "Accepted" )
So simple and so effective. Many thanks !!
Hi @Anonymous
Please try
PO Status =
VAR one_ = [Criteria 1]
VAR two_ = [Criteria 2]
RETURN
IF ( one_ < 1 || two_ > 0, "Rejected", "Accepted" )
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
15 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
12 |