Find Function in Calculated Column in PowerPivot always returns ERROR

Hello everybody,

I have created a calculated column in PowerPivot and inserted a formula that worked in a normal excel spreadsheet however, this formula does not work in PP anymore.

=find("green",Table1[Name],1)

Name column:
NAME: Bag green

it should find "green" in the name and return the position. Hoever it alway returns the error, that the find function could not find the string.

I have attached an example spreadsheet.