Forum Discussion
Pulling Data from Tags Field Azure Dev Ops
We are using Azure Dev Ops as our source and pulling it into Power BI. Our work items contains a bunch of tags in a specific schema. I want to be able to search if a work item contains a spec...
Thanks for replying so quick.
Here's a table and the outcome of what I want to achieve.
If I got you right, it it a really simple problem:
in Power Query you can easily use split by delimeter, then choose by ; on the delimeter type and finally you will have 3 different columns as you wish. You can change the column headers as your wish.
hope it helpI hope this helps.
If it does, please Mark as a solution.
I also appreciate Kudos.
What if it's something like this?
I want to be able to search if the Tags field contains Animal: or House: and have it pull whatever information is between that and the next semicolon (;). Is there a good if statement that can fulfil this?