Forum Discussion
Jebilaya
Helper III
Helper IIIsearch text not working
I need to return all characters before the "/" in driver name as a new column so i'm using the below DAX but it just errors with "The search Text provided to function 'SEARCH' could not be found in t...
MFelix
Super User
Super UserHi Jebilaya ,
You need to add the additonal parameter of the SEARCH funcion so your SEARCH should be similar to this:
SEARCH( "/", 'Table'[Column1],1,1)
Has you can see in the documentation if you ommit the last parameter it returns an error.
I have placed 1 so that when you do the -1 it does not trow an error on the left text.
