Use parameter in a new column

[sunitvyas]

Hi,

I have a created a new column in my dataset using a dax statemet that concatenates a hard coded URL and a value from another column (added example of dax below)

Name URL = CONCATENATE("https://www.xyz.com?id=", TRACK[ID])

I want to add a paramter instead of using this hard coded URL to get values in this new column as I have 2 different URLs that need to be appended to generate this data in the column. 

Is it possible to do this? Any help here is greatly appreciated. 

[JSR]

It's actually easy using Power Query.

I'm using 3 parametres and one colum.

[JSR]

Hi,

any luck fixing this issue?

Need to do the same, thanks.

[sunitvyas]

Hi @amitchandak 

Thanks for you response but that is not quite what I'm looking for. I have a report that needs to be published to two different workspaces and the URL in the column needs to be automatically set depending on the workspace. My thinking here is that a parameter will allow me to dyanmically change this URL in the column when I publish the report. Do you know if this is possible?

[amitchandak]

@sunitvyas , Create a measure then

Name URL  meausre= CONCATENATE("https://www.xyz.com?id=", [ID Measure])

or

Name URL = CONCATENATE("https://www.xyz.com?id=", max(TRACK[ID]) )