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 members,
I need help on this.
I have a table with a remarks column. The remarks column is unstructured with spacing, text, numbers, and symbols. This column contains many words, but it also includes keywords such as "A," "B," and "C."
I want to create an additional column and categorize the remarks column.
I have tried adding columns with “columns from an example”, but it does not work out.
May I know how to go about it? Thanks!
Solved! Go to Solution.
Hi @joeywong ,
How about use the conditional column? like this:
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi Vijay
Thanks in advance for your help.
Please find below an example for the Remarks and Categorize columns.
A new column, "Categorize," was added based on the Remarks column. Thanks!
Use this formula in a custom column where you will need to populate {"AA","BB","CC","DD"} appropriately.
= Text.Combine(List.Intersect({Text.Split([Remarks]," "),{"AA","BB","CC","DD"}}),", ")
Hi Vijay,
Thank you for your attempt to help. However, this solution does not work. There are some null rows in between.
Do you have any other solutions? Thanks!
Hi @joeywong ,
How about use the conditional column? like this:
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Use a try otherwise block
= try Text.Combine(List.Intersect({Text.Split([Remarks]," "),{"AA","BB","CC","DD"}}),", ") otherwise null
Can you give us an example of your Remarks column and how to categorize them? It will be easier for us to give the solution...
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.