Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two column one Column confirmation and another column Timing
Confirmation column have below three values
1.Confirmation
2.Not Confirmed
3.Pending
Confirmation as consider No Risk
Not Confirmed as Consider Risk
Pending as consider No Risk
Timing column have a following the values .
Overdue Purchase Requisition consider as Risk
Standard Overdue consider as Risk
Urgent Overdue consider as Risk
Urgent consider as Risk
Lack consider as Risk
No Timing Risk Consider as Risk
Now i want to create new calculated column name called RISK. this column would be a logical result of previous two columns.
i have assign two values for the following conditions
i have created condition its not working . any support . looking for support.
Solved! Go to Solution.
@THENNA_41 , Create a new column like
new column =
Var _1 =
Switch([Confirmation],
"Confirmation","No Risk",
"Not Confirmed","Consider Risk",
"Pending","No Risk",
"No Risk")
Var _2 =
Switch( true(),
[Timing] in {"Overdue Purchase Requisition","Standard Overdue","Urgent Overdue","Urgent","Lack","No Timing Risk"}, "Risk",
"No Risk"
)
return
if(_1 ="Nor Risk" && _2 = "No Risk", "No Risk", "Risk")
@amitchandak sir its showing all the values as Risk and there No Risk value also there. No Timing Risk is a consider as a No Risk and . if this value match with confirmation column Pending ,confirmation . its should return No Risk
@THENNA_41 , return has one spell mistake, Check that in formula
return
if(_1 ="Not Risk" && _2 = "No Risk", "No Risk", "Risk")
Hi,
Try something like this: IF(OR(Table[Confirmation] in {"Confirmation", "Not Confirmed"},Table[Timing] <> "No Timing Risk"),"Risk","No Risk")
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
Please,
can you share an exemple of teh file?
@THENNA_41 , Create a new column like
new column =
Var _1 =
Switch([Confirmation],
"Confirmation","No Risk",
"Not Confirmed","Consider Risk",
"Pending","No Risk",
"No Risk")
Var _2 =
Switch( true(),
[Timing] in {"Overdue Purchase Requisition","Standard Overdue","Urgent Overdue","Urgent","Lack","No Timing Risk"}, "Risk",
"No Risk"
)
return
if(_1 ="Nor Risk" && _2 = "No Risk", "No Risk", "Risk")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |