Search function Error in Power BI

[omeralitopal]

Hi,

I used the SEARCH function in Power BI but finds the location of the character I want to find incorrect.

Screenshot will tell you better.

Actually, I want to extract source system (android - ios etc).

Essentially I can do with SQL using instr - substr but I want to use DAX Language.

Please help.

[v-yulgu-msft]

Hi @omeralitopal,

In my test, I got 47 as the result.

Based on my assumption, the difference might be caused by some invisible characters inside the text string. I was not able to reproduce the same scenario on my side. Would you please send sample dataset file or .pbix file to me?

Best regards,

Yuliana Gu

[omeralitopal]

@v-yulgu-msft thanks 

i did this way >>>>>

=var str_start = search("Twitter for",[source])
var str_end = search("</a>",[source])
return mid([source],str_start, str_end-str_start)