Formule Search Text

Anything related to PowerPivot and DAX Formuale
annlee
Posts: 3
Joined: Thu Feb 23, 2017 8:19 pm

Formule Search Text

Postby annlee » Tue Aug 11, 2020 6:53 am

Hi,

I am trying to construct a formule in a column of powerpivot to find a part of text of other column (CN42N[Denominação]).

=if(isnumber(SEARCH("unassigned";CN42N[Denominação]));"05";"")

CN42N[Denominação] is the column in same page where I am trying to construct the formule.

This formule is giving error and I do not know what it is wrong. Could you help me, please?

Thank you

MattAllington
Posts: 1154
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Formule Search Text

Postby MattAllington » Tue Aug 11, 2020 4:17 pm

In my experience, the optional additional parameters for search are not optional, but required.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

annlee
Posts: 3
Joined: Thu Feb 23, 2017 8:19 pm

Re: Formule Search Text

Postby annlee » Tue Aug 11, 2020 6:09 pm

Hi,

Sorry, I did not understand. This means that it is not possible to construct the formule?

MattAllington
Posts: 1154
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Formule Search Text

Postby MattAllington » Wed Aug 12, 2020 6:09 pm

Yes it is possible, but you must supply all 4 parameters. The last 2 are not optional, they are required.
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: Bing [Bot] and 5 guests