Forum Discussion
Add conditional column using mesure to pic specific value and create new colum
I have created below table using mesure. All working as expected except the values in "Final Value" colum. The requirement is that if - 1. "Pass/Fail" column is = Ok than return "Pass" 2. "Pass/Fai...
Hi, Anonymous
You can try the following methods.
Column = SWITCH(TRUE(), SEARCH("OK",[Pass/Fail],,0)<>0,"Pass", SEARCH("Fail",[Pass/Fail],,0)<>0,"Fail", SEARCH("In Progress",[Pass/Fail],,0)<>0,"In Progress", SEARCH("Initial",[Pass/Fail],,0)<>0,"Not Started", "In Process")SEARCH function (DAX) - DAX | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Correction -
If the "Pass/Fail" value contains "Fail" than it should returm "Fail".
Hi, Anonymous
You can try the following methods.
Column = SWITCH(TRUE(),
SEARCH("OK",[Pass/Fail],,0)<>0,"Pass",
SEARCH("Fail",[Pass/Fail],,0)<>0,"Fail",
SEARCH("In Progress",[Pass/Fail],,0)<>0,"In Progress",
SEARCH("Initial",[Pass/Fail],,0)<>0,"Not Started",
"In Process")
SEARCH function (DAX) - DAX | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.