create custom URL (exchange specific part with field value)

[baneworth]

Dear Community,

I couldnt find any threads or info is this is even achieveable.

My Issue:

I have a URL to access our product infos (nothing changes in the URL except the numbers in organge for different products). I do have the changing numbers avialable as a field in a table (lets call it SERIALNR). 

I want to create a new URL now where i add the Field instead of the number as below and add it to the table where the products are.

How would i do that?

A calculated column, a measure or something else?

Best regards

[johnt75 · Accepted solution]

Add a calculated column e.g.

Product URL = "https://domain.com/path/to/" & 'Table'[ID number] & "any/more/path"

then from the Data Category drop down select Web URL. You can then put that in any table visuals and turn on the URL icon option. Or you could add it to a column in a table visual as conditional formatting -> Web URL.