Find Multiple String

[HenryJS]

Hi all,

How can I write the below DAX to include multiple strings. Not just "KP -"?

• "Perm Placed"
• "KP -"
• "Estimator"

KP? = IF( FIND("KP - ",[Profile Skills],1,0)=0,BLANK(), "Yes")

[amitchandak · Accepted solution]

@HenryJS ,

refer

https://www.edureka.co/community/28849/how-can-i-search-for-multiple-strings

https://community.powerbi.com/t5/Desktop/DAX-expression-looking-up-multiple-values-with-a-unique-sea...

https://community.powerbi.com/t5/Desktop/Unable-to-run-multiple-text-search-in-string-to-create-a-ne...

https://community.powerbi.com/t5/Desktop/String-Text-search-for-keywords-in-multiple-columns/td-p/41...