Forum Discussion
Use parameter in a new column
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.
4 Replies
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]) )
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?
Hi,
any luck fixing this issue?
Need to do the same, thanks.
It's actually easy using Power Query.
I'm using 3 parametres and one colum.
