Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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...
Need Help
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    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.

     

rubinboer's avatar
rubinboer
Resolver II
2 years ago

hi Anonymous 

 

your evaluation is on a different column [MaxFlow], based on yyour requirement you need to evaluate the ["Pass/Fail"] Column.

 

your evaluation will be something else based on your data tho:

Switch ( 'yourcolumn'[Pass/Fail],

"OK" ,"Pass", 

"Errors", "Fail" ,

"In Progress", "In Progress",

"Initial ", "Not Started" ,

"In Process"

)

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

rubinboer 

 

Thanks a lot for replying !

Your solution works, i have another requirement in addition to the one that you have givn to me. If the "Pass/Fail" value contains "Errors" than it should returm "Fail". 

 

For all other combinations\(as displayed on the screen below), it mest me "In Progress"