Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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
Proud to be a Super User!
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.
@Anonymous , refer if this video can help
https://www.youtube.com/watch?v=YxZ_8-vsEpE
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |