Hello All -
I am trying to add a calculated column in my Data Model to search for a text match within a column. I tried
on a worksheet, and it works fine. However, recreating this in the Data Model, as
(where Table[Column] is the column to search) returns an error: "The search Text provided to function 'SEARCH' could not be found in the given text." Is this not possible within the DM? Is there another way of approaching this? Note that the text values that I'm looking for are fuzzy searches, that is the value in the search column could be "Kid's Book", or "Paperback Book", etc.
Thanks!
Bookmarks