Create weburl

[KevinMorneault]

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.

[KevinMorneault]

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]

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.