Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Multiple search text in if function

Hi,

 

Have data in a column as 

Category
I need a help with PR approval
I need help creating a Purchase Request (PR)
I need help with a BuyNow contract
I need help with a new supplier contract or sourcing event
I need help with an intervention (approval) group in BuyNow
I need help with IQN Training/ Technology
I need information on Process and Policies
I need information on procurement Corporate Citizenship policies and requirements
I need to change the PR/PO
I need to Enable a Contractor
I need to exit
I need to find a Contractor
I Need to manage

 

in new column would like to have if above column contains help then "Help" or Change then "Change" .......

So final column should be like this 

 

New_Category

Help
Information
Change
Enable
Exit
Contractor
Manage
Find


Any other solution would be great.Getting error when I have have tried with if(search(column,"Help"),"Help", if(search(Column,"Change"),"Change"......................

Thanks 

Murali

Need Help
  • Floriankx's avatar
    Floriankx
    8 years ago

    Hello,

     

    you can try switch for your calculated column:

    SWITCH(
 FALSE(),
  ISERROR(SEARCH("Find",[Category])),"Find",
  ISERROR(SEARCH("Enable",[Category]),"Enable",
  "New")

    SEARCH only works with row context, so it is not recommended to be used in Measures.

4 Replies

  • Floriankx's avatar
    Floriankx
    Solution Sage
    8 years ago

    Hello,

     

    SEARCH is probably the best way to do it.

    Can you give us your full formula and the occuring error message?

     

    Best regards

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      THhis is the Dax formula i tried

      Categ_New = IF(SEARCH("Find",'Raw Data Report'[Category]),"Find",IF(SEARCH("Enable",'Raw Data Report'[Category]),"Enable","New") )

       

      Getting Error message: the search Text provided to function 'SEARCH' could not be found in the given text.

      • Floriankx's avatar
        Floriankx
        Solution Sage
        8 years ago

        Hello,

         

        you can try switch for your calculated column:

        SWITCH(
 FALSE(),
  ISERROR(SEARCH("Find",[Category])),"Find",
  ISERROR(SEARCH("Enable",[Category]),"Enable",
  "New")

        SEARCH only works with row context, so it is not recommended to be used in Measures.