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.
Hello. I have a data that contains comments from user for example:
1. The price is too high
2. Not suitable for my house
3. High price
4. The price is too expensive, other store offer lower price
5. The products is faulty
6. the products quality is bad
7. The price is too high and it's not suitable for my house
I'm trying to categorize the reason into a new columns called 'Categories'. The data will be for example: High Price, Quality Issues, Suitability Issues and such. I have used the IFERROR but it's not that efficient
Price = IF ( IFERROR ( SEARCH ( "pric", 'data'[comments] ), 0 )=0, BLANK(), "Price")
Solved! Go to Solution.
Hi @Anonymous
I would suggest you may create a table2 as below. Then you may create the calculated column with CONCATENATEX Function. Here is the similar post for your reference.
Column = CONCATENATEX ( FILTER ( Table2, SEARCH ( Table2[Key], Table1[comment], 1, -1 ) > 0 ), Table2[Category], " and " )
Regards,
Cherie
Hi @Anonymous
I would suggest you may create a table2 as below. Then you may create the calculated column with CONCATENATEX Function. Here is the similar post for your reference.
Column = CONCATENATEX ( FILTER ( Table2, SEARCH ( Table2[Key], Table1[comment], 1, -1 ) > 0 ), Table2[Category], " and " )
Regards,
Cherie
Thank you for your help! I'll try them
Hi,
See if my solution here helps - Search for multiple phrases within a cell and extract all those phrases in another column.
Hope this helps.
Thank you for your help!
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 |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |