Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Bug or Documentation Error for FIND

Been playing with the FIND and SEARCH functions and believe there is an issue with FIND. Was wondering if anyone else could confirm before I submit an issue or bug report. Essentially, wildcards do not seem to work at all with FIND despite the documentation that they do.

 

https://msdn.microsoft.com/en-us/library/ee634882.aspx

 

They work fine with SEARCH. 

General Comment

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    Hi Greg_Deckler,

     

    I can also reproduce the same issue with the latest version(2.54.4970.761 64-bit (January 2018)) of Power BI Desktop. :smileyhappy:

    Column = FIND("?SA",'Country Population'[Country Name],,-1)
    Column 2 = SEARCH("?SA",'Country Population'[Country Name],,-1)

     

    Regards