Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
Hello,
SEARCH is probably the best way to do it.
Can you give us your full formula and the occuring error message?
Best regards
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.
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.
It Worked Thanks Florian.. You are great..
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |