Forum Discussion

pankaj_2086's avatar
pankaj_2086
Frequent Visitor
6 years ago
Solved

how to attach url(link) to column values

hello everyone,

actually I am stuck with one task for a long time, I have one table in which there are some IDs of employees and I want to attach the link to those id's so that whenever I click on them I will get directed to that link in the browser.

 

I have already made a URL link using DAX.

PFB attachment for more information.

As we can see in the above image there is one column named Final URL with links buttons, I want those links to be attached to the Work Item Id column for eg if we click on 3829 the link should open in the browser.

 

Using DAX expression I have made url link as,

Final URL = CONCATENATE('Work Items - All history by month'[Intial URL]&'Work Items - All history by month'[Project Name]&"/"&"_Workitems"&"/"&"edit"&"/",'Work Items - All history by month'[Work Item Id]&"/")

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      Is your problem resolved?

      Don't hesitate to give Kudos and mark it as a solution.
      • pankaj_2086's avatar
        pankaj_2086
        Frequent Visitor

        actually it's in my office system so I will try to solve it tomorrow. I will get back to you if I get stuck anywhere

        thank you, Praveen.