topic How to print true when the column contain a value in DAX Commands and Tips

How to print true when the column contain a value

Hadill — Wed, 16 Feb 2022 07:23:06 GMT

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

Re: How to print true when the column contain a value

PijushRoy — Wed, 16 Feb 2022 07:44:06 GMT

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