createing web url columns from azure devops backlogs item

[Anonymous]

Hello dear community,

I need help to constructing an URL for my backlog items in power bi desktop. In my data I don,t have any URL column so I guess I need to create a URL columns alt measure, but how?

I'd like to create a hyperlink for each item so that when a user selects one it the corresponding item in devops will opens.

I,ll be more greatful if someboody can help me!

[amitchandak]

@Anonymous , I think you need to have a measure like

measure = "https://<URL>?item="& max(Item[Item])

if column is possible then

measure = "https://<URL>?item="& (Item[Item])

[Anonymous]

@amitchandak Hi and thanks for your response , I did try the measure, but the resulting wrong URL. 

I try it like that measure = "https://<URL>?item="& max(Item[Title]) and it return error URL.

And I have about 1500 items that I bring from azure devps and thoses item updates daily as well. What I need is create a hyperlink for each item so that when I select one item from power bi it takes me to the correspondig item in devops?

[Anonymous]

@amitchandak do you have any idea can help me to get the backlog items link from azure devops?