Solved: help with Search function

vjnvinod · ‎09-08-2020

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"

Greg_Deckler · ‎09-08-2020

@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"
)

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

amitchandak · ‎09-08-2020

@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/

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Greg_Deckler · ‎09-08-2020

@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"
)

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...