How to print true when the column contain a value

[Hadill]

Hi there,

I want to print true if a certain column contains cells with a certain word. **contain and not equal**

the Contain function brings me true for the equal cells only.

Is there a specific function or way to do this? 

thanks in advance

[PijushRoy · Accepted solution]

Hi,

Please try this

Yes/No = IF(SEARCH("Electrical",Data[Group/Category],,2)=1,"Yes","No")

Also you can create Conditional Column in Power Query

If you have any question, please let me know.
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

Thanks