Azure Devops split by delimiter

[ashley_white]

Hello,

I was able to successfully split by Azure Devops tags in powerbi modifying the query but in Azure it organizes the tags alphabetically which is not ideal. I need specific tags in one column but cannot figure out when splitting by the delimiter how to tell it where to put what tags or if that is possible. Please help! If this is possible please help 😄 

[amitchandak · Accepted solution]

@ashley_white , First split into rows and then use pivot

https://radacad.com/pivot-and-unpivot-with-power-bi