Dropping a field into a URL

[RMDNA]

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]}

[GilbertQ · Accepted solution]

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.

[RMDNA]

@GilbertQ, down in one, thank you! I've tried working with Add by Example before but it was always too finicky to work. This worked great.

[GilbertQ]

Awesome @RMDNA glad it solved your issue.