New column in power query based on key word search

[Anonymous]

Hi Experts

I have in my table two key columns EUC Name and EUC Description. I want to search both columns and if I find the following keybwords in either column 

Macro

Calculator 

Forms

Workflow

Lookup

Dashboard

Data Store

Financial Model

Then populate Y into a new column otherwise N.

[PhilipTreacy]

Hi @Anonymous 

It's always best to provide some real sample data so code cna be written specifically against it.

You could use List.ContainsAny or Text.Contains, depends on the source data.

This blog post exaplains several examples of searching for text

https://www.myonlinetraininghub.com/searching-for-text-strings-in-power-query

Regards

Phil

[Icey]

Hi @Anonymous ,

Please refer to this blog: DAX – “CONTAINSX” – Finding if a value in table 1 has a matching value in table 2.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@Anonymous , refer if this video can help

https://www.youtube.com/watch?v=YxZ_8-vsEpE