I need some help with a fairly easy DAX statement. I'm trying to calculate a column the produces 1, 0 based on a SEARCH function nested in an IF statement. The text I'm searching for in my original column is "LSB." However, "LSB" is a substring, not the full string. And "LSB" has different starting positions in different values throughout the column (not sure if this matters, but just pointing that out).
I keep getting the error message: "Calculation error in column 'table': The search Text provided to function 'SEARCH' could not be found in the given text."
= IF(SEARCH("LSB", [Column]) > 0, 1, 0)
Any suggestions??? Where's my mistake? Thanks much.