Forum Discussion
Search multiple text in one column
I'm trying to search multiple text in a column and to categorize it accordingly.
for
and I'm currently using:
The output should be like below:
PROCEED TO SEMESTER 2 = PROCEED TO SEMESTER
PROCEED TO SEMESTER 2 AND REPEAT FAILED MODULE(S) IN JULY 2018 = PROCEED TO SEMESTER AND TO REPEAT
However using the Calculation its not giving me the right category, help me please...
is it a measure or a column
The first condition you have to split
Search("Proceed to Semester",[Column],1,0)>0 && Search("To Repeat",[Column],1,0)>0
Change column name and text as per need
4 Replies
Hi, buzzkoi69
Based on your description, I created data to reproduce your scenario.
Academic Progress:
You may create a measure as below.
Result = var _value = SELECTEDVALUE('Academic Progress'[Recomendation]) return SWITCH( TRUE(), CONTAINSSTRINGEXACT(_value,"PROCEED TO SEMESTER")&&CONTAINSSTRINGEXACT(_value,"AND REPEAT"),"PROCEED TO SEMESTER AND TO REPEAT", CONTAINSSTRINGEXACT(_value,"TERMINATION"),"TERMINATION", CONTAINSSTRINGEXACT(_value,"PROCEED TO SEMESTER")&&NOT(CONTAINSSTRINGEXACT(_value,"TO REPEAT")),"PROCEED TO SEMESTER", BLANK() )Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-alq-msft Thank you, will try this solution as well!
is it a measure or a column
The first condition you have to split
Search("Proceed to Semester",[Column],1,0)>0 && Search("To Repeat",[Column],1,0)>0
Change column name and text as per need
amitchandak It works! Thank you so much for your help
