Concatenate help

[Anonymous]

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

[Zubair_Muhammad]

Hi @Anonymous

Try wrapping it inside SELECTEDVALUE function

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

[robofski]

@Anonymousyou 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.

[Anonymous · Accepted solution]

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]

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).