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.
I have a column of string data that has various lengths ([Company Name]. Within this column I'd like to search for a word e.g. Meat. and group these into a category "Meat/poultry/fish".
Company Name | location, other grouping |
Meats by Company A | Meat/poultry/fish |
Meats by Company B | Meat/poultry/fish |
Company C Meat Incorporated | null |
I've tried SWITCH, FIND, CONTAINS STRING columns but it keeps find those that have the word Meats at the begining of the text string rather than in the middle or end.
Columns tried :
location, other Grouping1 =
IF(CONTAINSSTRING('Events'[location, other],"*Meat"),"Meat/poultry/fish",'Events'[location, other])
location, other Grouping = SWITCH(
TRUE(),
FIND("Meat",'Events'[location, other],1,0)=1,"Meat/poultry/fish",
FIND("*Meats*",'Events'[location, other],1,0)=1,"Meat/poultry/fish",
SEARCH("*meats*",'Events'[location, other],,0)=1,"Meat/poultry/fish")
Solved! Go to Solution.
Here is one way to do it. You were setting your SEARCH =1 which is why it only looked at the beginning.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Here is one way to do it. You were setting your SEARCH =1 which is why it only looked at the beginning.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |