Forum Discussion

omeralitopal's avatar
omeralitopal
New Member
7 years ago

Search function Error in Power BI

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 (an...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

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's avatar
omeralitopal
New Member
7 years ago

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)