topic Re: Create weburl in DAX Commands and Tips

Create weburl

KevinMorneault — Tue, 26 Sep 2023 19:41:48 GMT

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.

Re: Create weburl

KevinMorneault — Tue, 26 Sep 2023 20:39:38 GMT

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.

Re: Create weburl

KevinMorneault — Tue, 26 Sep 2023 20:41:30 GMT

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.