Forum Discussion
Solution SageDropping a field into a URL
I have a field [ID] in a table which is a component of a URL that will link it to our CRM system.
(e.g. the CRM link for an item with ID of [ABCD] would be: http://database/main.aspx?id={ABCD}.)
How do I create a custom column which would be a URL of this ID? That is, I would like to create a custom column of
http://database/main.aspx?id={[drop ID here]}
Hi RMDNA
You could do this in the Query Editor and if you have got the latest version of Power BI Desktop, you can use the Add Columns from Example.
In the example field, put what you have below, and see if it can complete it for you.
If that does not work, then in the Query Editor, you can add a Custom Column and put in the following syntax in the "Custom column formula:"
"http://database/main.aspx?id=" & [ID]
Then load the data and make sure to change the Data Category in the Modeling Ribbon to Web URL for the link to work.
3 Replies
- GilbertQ
Super User
Hi RMDNA
You could do this in the Query Editor and if you have got the latest version of Power BI Desktop, you can use the Add Columns from Example.
In the example field, put what you have below, and see if it can complete it for you.
If that does not work, then in the Query Editor, you can add a Custom Column and put in the following syntax in the "Custom column formula:"
"http://database/main.aspx?id=" & [ID]
Then load the data and make sure to change the Data Category in the Modeling Ribbon to Web URL for the link to work.
