Forum Discussion

KevinMorneault's avatar
KevinMorneault
Helper II
2 years ago

Create weburl

Hi All

 

What i am trying to do is the following i have 2 column 

1) Investment_ID

2) Project_ID

For example investment id would be  5400946 and Project ID could be PRJ-23456

When you would select Project id, it would use the Investment ID to redirect you to the webpage. so basically the link would look something like this

 

project/5400946/details.

 

what would be the syntax or string use here in dax. 

 

The goal here is in the dashboard, any project you would select, it would redirect you to the details of the specific project, which the InvestmentID would be the key. 

 

I hope i provided enough information and that it is clear.

 

 

 

 

Help

2 Replies

  • KevinMorneault's avatar
    KevinMorneault
    Helper II
    2 years ago

    as an update, i have try this following as a query in power by

    I added a column with category WebURL and added the following code

     

    WebURLink = "http://project/" & TableName[Investement_ID]

    when doing this its redirecting and telling me i dont have access but i do. Wandering if its because i am missing something. When going to the web original link would be something like this 

     

    project/5400946/details.

     

    I would be missing details at the end. Could this be the issue.

     

     

     

     

    • KevinMorneault's avatar
      KevinMorneault
      Helper II
      2 years ago

      Hi All

      As an update, i have been trying to try different things, and if i copy paste the url in the browser, it will bring me to the proper page with project details. Its only when i select the url within the dashboard, it's redirecting but giving the error of missing access.