Forum Discussion

wrwillits's avatar
wrwillits
Helper III
8 years ago
Solved

Error in FIND function

I am trying to use the Find Function but keep getting an error message every time I try to save the calculated column. I am trying to find the "(" text within a text column and PBI throws an error stating that "The Search Text provided to function "FIND" could not be found in the given text." Here's an example of the column for the "given text":

 

Aircraft (Serial #)      Aircraft Type

AS365 (65533)

AW139 (399443)

S-92 (7649246)

 

I am trying to pull out the "Aircraft" type from the "Aircraft (Serial #)" column so my formula is:

 

Aircraft Type =

                     LEFT( [Aircraft (Serial #)],

                               FIND( "(", [Aircraft (Serial #)] ) - 1

                            )

 

It seems that the FIND function in DAX will not accept the "(" as the text to find, and instead assumes that the "(" is part of the formula. It of course works fine in Excel.

 

  • wrwillits

     

    Please make sure that you're using the latest version of PBI Desktop. I just tested with your formula and it worked well on my side as following screenshot.

     

     

    trevor

     

    You need to change 0 to 1 in your formula.

     

    Best Regards,
    Herbert

3 Replies

  • Similarly, I am having trouble with the FIND function,  I have a Text column [Cost Type] in a table and am trying to find if the word "Freight" appears in the value:

     

    find("FREIGHT",[Cost Type],0)

     

    Power BI is telling me "An argument of function 'FIND' has the wrong data type or has an invalid value."

     

    It seems the function won't accept "Freight" as an argument either, so it's not limited to the ( character.

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee

    wrwillits

     

    Please make sure that you're using the latest version of PBI Desktop. I just tested with your formula and it worked well on my side as following screenshot.

     

     

    trevor

     

    You need to change 0 to 1 in your formula.

     

    Best Regards,
    Herbert

    • wrwillits's avatar
      wrwillits
      Helper III

      I updated to the Nov release and it now works.

       

      Thanks!