Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
The data I have has a column called "Tags" that I need to transform into something more meaningful.
The "Tags" column is plain text and has contents that look like this: #store-aisle-product
There are other values in the Tags column as well, but this is the only one I care about. So what I need to do is the following:
I've been looking at the documenation and some examples here for various split and add column functions, but the Power Query syntax still reads like so much Greek to me 😞
Solved! Go to Solution.
Hey @Zelbinian
Try out the Column From Examples option in the Query Editor. It's codeless and you can tell Power BI which part of the field that you would like to extract and it can then infer from a couple of examples what it should do for the rest of the records. Give it a try and let me know if it works for your case!
Parker
Hey @Zelbinian
Try out the Column From Examples option in the Query Editor. It's codeless and you can tell Power BI which part of the field that you would like to extract and it can then infer from a couple of examples what it should do for the rest of the records. Give it a try and let me know if it works for your case!
Parker
Well that's some straight-up witchcraft. Thanks!