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.
hi Anonymous
Try:
yourMeasure = IF( CONTAINSSTRING( 'yourTable'[Pass/Fail], "Errors" ), "Fail" , "In Progress" )