search text not working

[Jebilaya]

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 the given text."  I have tried other characters and it's just not finding it.  The driver name column is setup as text.

Driver = left('Timeslots HDx Report'[Driver Name],search("/",'Timeslots HDx Report'[Driver Name])-1)

[MFelix · Accepted solution]

Hi @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)

https://dax.guide/search/

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.

[MFelix · Accepted solution]

Hi @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)

https://dax.guide/search/

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.

[Jebilaya]

@MFelix   Still the same error 😞

[MFelix · Accepted solution]

Try the iferror with 1 not 0.

[Jebilaya]

that was great thanks @MFelix  ... now stuck on my next one for the other side.

The len part of the function is producing a number when I run it on it's own but when I put it as part of the right statement I get the below error

[MFelix]

Try to add a IFERROR on the Second part of the metric.

[MFelix]

Try to add a IFERROR on the Second part of the metric.