Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
i need a frormula if an employee has only step ID "Plan+DO+Act"then give me as result succeed. see picture below
Solved! Go to Solution.
I would say create a numeric column, converting the text values of Step ID to numeric values. Then sum them together to determine which combination it is.
For example
6 + 2 + 8 = 16 = "Pending"
1 + 3 + 5 = 9 = "Initiated"
You just have to make sure that the combinations aren't intersecting, so i wouldn't use something so simple as 1-10!
We have in total 10. and every time it's another formula. so one formula is step ID 1,3 and 5. other formula is step ID 6,2,8
I would say create a numeric column, converting the text values of Step ID to numeric values. Then sum them together to determine which combination it is.
For example
6 + 2 + 8 = 16 = "Pending"
1 + 3 + 5 = 9 = "Initiated"
You just have to make sure that the combinations aren't intersecting, so i wouldn't use something so simple as 1-10!
User | Count |
---|---|
93 | |
87 | |
77 | |
72 | |
66 |
User | Count |
---|---|
116 | |
107 | |
88 | |
65 | |
63 |