cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Andshepch Regular Visitor
Regular Visitor

Concatenate help

Hi,

 

I am new to Power BI, but making progress, however I have a problem that I can't figure out.

 

I have  created a Table Visualization with a text column called "Opportunity ID2", and some other fields (value, name,,,) 

 

What I need to do is add a column that concatenates the values in "Opportunity ID2" with a URL.

 

I have tried the most obvious solution on here https://community.powerbi.com/t5/Desktop/Need-to-create-hyperlink-in-power-bi-i-have-a-unique-record...

 

but when I add the URL and type the & I can't get the filed name "Opportunity ID2" to work

 

like this (xxxxxxxx is replacing my company name:

 

Measure = "https://xxxxxxxxx.my.salesforce.com/" & Opportunity ID2

 

PLease can you help?

 

Thank you

 

Andrew

1 ACCEPTED SOLUTION

Accepted Solutions
Andshepch Regular Visitor
Regular Visitor

Re: Concatenate help

Thanks for the replies - I did say I was new to this!

 

It was the syntax of the TableName that was catching me out i tried the SELECTEDVALUE approach, but that just gave me the URL and not the other column, but it did show me how to get the field name in the expression,

 

I have solved it now by adding brackets and single quotes to the table name like this:

 

Link to Opp = "https://xxxxxxxx.my.salesforce.com/" & ('Current Quarter'[Opportunity ID2])

 

an dthis now works for me. Thanks

 

Andrew

 

 

4 REPLIES 4
Super User
Super User

Re: Concatenate help

Hi @Andshepch

 

Try wrapping it inside SELECTEDVALUE function

 

Measure = "https://xxxxxxxxx.my.salesforce.com/" & SELECTEDVALUE(TableName[Opportunity ID2])

robofski Member
Member

Re: Concatenate help

@Andshepchyou talk of wanting to add a column but then you show your using a measure??

 

If you want to add a column then NewColumn = "https://xxx.salesforce.com/" & TableName[Oppourtunity ID2] works a treat, just be sure to change the data category on the modeling ribbon to be a web URL.

Andshepch Regular Visitor
Regular Visitor

Re: Concatenate help

Thanks for the replies - I did say I was new to this!

 

It was the syntax of the TableName that was catching me out i tried the SELECTEDVALUE approach, but that just gave me the URL and not the other column, but it did show me how to get the field name in the expression,

 

I have solved it now by adding brackets and single quotes to the table name like this:

 

Link to Opp = "https://xxxxxxxx.my.salesforce.com/" & ('Current Quarter'[Opportunity ID2])

 

an dthis now works for me. Thanks

 

Andrew

 

 

robofski Member
Member

Re: Concatenate help

Glad you got it sorted, and don't apologise for being new to it, we were all new once!

 

The intellisense in Power BI is usually really good at taking care of all that stuff for you, I always start typing the field I want and then select it from the offered list so it populates correctly with the table name etc automatically using quotes where required (I think only if there is a space in the table name are single quotes required).