In a column of powerpivot, I am trying to construct a formule to search part of text and give me a description. But the formule is giving me ERROR (column Tipo Projecto).
I'd recommend using PowerQuery for Calculated column. As evaluated value does not change with filter or any other context change within the model itself.
But, when using SEARCH/FIND in DAX, 4th argument is optional, but if partial string isn't found (anywhere in the column), it returns error.