• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

formule search text

annlee

New Member
Hi,

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).

=if(isnumber(search("unassigned time";CN42N[Denominação]));"07")

Could you help me please? Thank you
70586
 
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.

Try something like...
=IF(SEARCH("unassigned time";CN42N[Denominação];;0))>0;"07";0)
 
Last edited:
Back
Top