help with Search function

[vjnvinod]

Hi Team,

below is my coloumn

and calculated coloumn

status =

IF(SEARCH("NoNoNo",'Ch2 GCSPs'[Region&SLnow&oldSL&exception&TBC&Duplicate],1,0)>0,"In Markets, Other SMU"

Currrently i have given "NoNoNo" as a search criteria

now i need output based on 2 combinations

CBS and NoNoNO

basically if a text row contains CBS and NoNo then give me the output as "In Markets, other SMU"

[amitchandak]

@vjnvinod , Search is not case sensitive, so should work

refer if power query can help

https://www.youtube.com/watch?v=YxZ_8-vsEpE

refer fuzzy matching can help :https://www.poweredsolutions.co/2019/03/26/fuzzy-matching-in-power-bi-power-query/

[Greg_Deckler · Accepted solution]

@vjnvinod 

status =
IF(
  SEARCH("NoNoNo",'Ch2 GCSPs'[Region&SLnow&oldSL&exception&TBC&Duplicate],1,0)>0 &&
    SEARCH("CBS",'Ch2 GCSPs'[Region&SLnow&oldSL&exception&TBC&Duplicate],1,0)>0,
  "In Markets, Other SMU"
)

[vjnvinod]

@Greg_Deckler 

thanks so much, this worked