IF CONTAIN WITHIN FIELD ON TABLE

[Anonymous]

Dear Tim

another question coming ...

i have table with categories from each name of product .

im looking the way how to get STATUS by text contains .

if CATEGORY contain AA then A , else B

Thanks

Syaiful

[amitchandak]

Create a new Column not measure

status= if(table[category]="AA","A","B")

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

thanks for respond ,
anyway im looking for contain , not only based on IF .
let say i have AA1,AA2,AA3 . all result on AA ..

Thanks

Syaiful

[amitchandak]

Use search

status= if(search("AA",table[category])>0,"A","B")

[Anonymous · Accepted solution]

giving error result

"The search Text provided to function 'SEARCH' could not be found in the given text."

i found solution

i used this

status= if(search("AA",table[category],0,1),"A","B")