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
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.
Thanks!
I am trying to add a calculated column in my Data Model to search for a text match within a column. I tried
Excel Formula:
IF(ISNUMBER(SEARCH("Book",A1)),TRUE,FALSE)
Excel Formula:
IF(ISNUMBER(SEARCH("Book",Table[Column])),TRUE,FALSE)
Thanks!