Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
101 | |
78 | |
69 | |
63 |
User | Count |
---|---|
141 | |
106 | |
101 | |
85 | |
72 |