Forum Discussion
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-id/m-p/114613#M48310
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
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
Hi Anonymous
Try wrapping it inside SELECTEDVALUE function
Measure = "https://xxxxxxxxx.my.salesforce.com/" & SELECTEDVALUE(TableName[Opportunity ID2])
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.
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
