An argument of function 'SEARCH' has the wrong data type or has an invalid value

[SteveCarter1]

This has got to be simple but I just can't see it.

Can anyone tell me why I get that error?

I am trying to create a new column and just want the number of the location of the search text in the new column. The new column has a data atype of Whole Number.  My real requirement is to do this search against another column but that was failing so thought I'll just prove this function does work as expected so put in the actual text I want to search, negating any data type issues of the column I want to use.

[amitchandak · Accepted solution]

@SteveCarter1 , the Third argument can be min 1. DAX we do not have index 0. so leave it blank or start from 1 or  more

[SteveCarter1]

Thanks Amit! I knew it had to be simple