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 st...
Data Modeling
  • v-haibl-msft's avatar
    v-haibl-msft
    8 years ago

    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

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
8 years ago

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
8 years ago

I updated to the Nov release and it now works.

 

Thanks!