Solved: SEARCH multi values

nkasdali · ‎02-06-2018

Hi All,

Can you help me with using the SEARCH() Function with more than one value ?

Exp :

SEARCH(UserName;"SELE_MOE";"SELE_RL";"TMA";"SELE_EXP";"SELE_STD";"SELE_LIB")

Thanks

Greg_Deckler · ‎02-06-2018

Column = SEARCH("ce",[Category],1,0) || SEARCH("ware",[Category],1,0)

or

Column = SEARCH("ce",[Category],1,0) && SEARCH("ware",[Category],1,0)

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...

Greg_Deckler · ‎02-06-2018

Column = SEARCH("ce",[Category],1,0) || SEARCH("ware",[Category],1,0)

or

Column = SEARCH("ce",[Category],1,0) && SEARCH("ware",[Category],1,0)

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...

SEARCH multi values