Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
sunitvyas
New Member

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 4
JSR
Helper II
Helper II

It's actually easy using Power Query.

I'm using 3 parametres and one colum.

 

JSR_0-1716978703353.png

 

JSR
Helper II
Helper II

Hi,

any luck fixing this issue?

Need to do the same, thanks.

sunitvyas
New Member

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
Super User
Super User

@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]) )

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.