Create a new column based on excisting with a hyperlink.

[Anonymous]

Hi, i'm new to PowerBI.

I'm trying to create a new column based on my excisting column "ID"

In this new column I want to add a hyperlink + the ID added to this.

i.e https://welcome/{id}

I thought this was possible with custom column, but I can't seem to figure it out. 

[PattemManohar · Accepted solution]

@Anonymous  Try this as a "Custom Column" in "Power Query Editor"

=Text.Combine({"https://welcome/{", Text.From([ID], "en-GB"), "}"})

[Sowjanya_09]

What is "en-GB"

=Text.Combine({"https://welcome/{", Text.From([ID], "en-GB"), "}"})

[Anonymous]

Thanks a lot this works for me!