Forum Discussion
Solved
Categorizing a Narrative based on keywords
I have a Table containing a Narrative field. I have another table (Categories) with Keyword - Category pairs. I want to add a measure into Table that will search for Keword in Narrative and returns t...
PetrM , You have to create this as a column; the above formula
or a measure like
Category =
VAR NarrativeText = max(Table[Narrative])
RETURN
MAXX(
FILTER(
Categories,
CONTAINSSTRING(NarrativeText, Categories[Keyword])
),
Categories[Category]
)
PetrM , You have to create this as a column; the above formula
or a measure like
Category =
VAR NarrativeText = max(Table[Narrative])
RETURN
MAXX(
FILTER(
Categories,
CONTAINSSTRING(NarrativeText, Categories[Keyword])
),
Categories[Category]
)
Thanks amitchandak, the column version worked for me. This helped me a lot. I really appreaciate it!