- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Huge Number of Phrases to Search For
Hi Everyone,
I'm struggling with the best way to approach this. I've got a text column that I need to search for unique phrases and assign a tag to it (there's 22 tags to assign). For each tag, I've got 20 to 40 phrases to search for.
I've thought about something like this:
Column =
SWITCH(TRUE(),
CONTAINSSTRING([TextColumn], "phrase 1"), "tag 1",
CONTAINSSTRING([TextColumn], "phrase 2"), "tag 1",
CONTAINSSTRING([TextColumn], "phrase 3"), "tag 1",
CONTAINSSTRING([TextColumn], "phrase 4"), "tag 1",
CONTAINSSTRING([TextColumn], "phrase 5"), "tag 1",
CONTAINSSTRING([TextColumn], "phrase 6"), "tag 2",
CONTAINSSTRING([TextColumn], "phrase 7"), "tag 2",
CONTAINSSTRING([TextColumn], "phrase 8"), "tag 2",
)
But I'm not sure this is the best approach. Would anyone have a recommendation? Thanks!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@thecelerygod Create a table of your tags and phrases. Then you could write DAX like this:
Column =
VAR __Text = [Text Column]
VAR __Table =
ADDCOLUMN(
'Phrases',
"Found", CONTAINSTRING( __Text, [Phrase] )
)
VAR __Result = CONCATENATEX( FILTER( __Table, [Found] = TRUE() ), [Tag], ", " )
RETURN
__Result
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@thecelerygod Create a table of your tags and phrases. Then you could write DAX like this:
Column =
VAR __Text = [Text Column]
VAR __Table =
ADDCOLUMN(
'Phrases',
"Found", CONTAINSTRING( __Text, [Phrase] )
)
VAR __Result = CONCATENATEX( FILTER( __Table, [Found] = TRUE() ), [Tag], ", " )
RETURN
__Result
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That's fantastic. Thanks!

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
05-20-2024 12:19 PM | |||
11-11-2024 03:32 AM | |||
10-19-2024 11:55 AM | |||
12-17-2022 12:32 AM | |||
05-03-2024 12:14 PM |
User | Count |
---|---|
27 | |
26 | |
25 | |
13 | |
10 |
User | Count |
---|---|
24 | |
21 | |
18 | |
17 | |
10 |