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 (android - ios etc).

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

 

Please help.

 

 

 

Need Help

2 Replies

  • 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)