Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |