Forum Discussion
Create a new column based on excisting with a hyperlink.
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.
Anonymous Try this as a "Custom Column" in "Power Query Editor"
=Text.Combine({"https://welcome/{", Text.From([ID], "en-GB"), "}"})
3 Replies
- PattemManohar
Community Champion
Anonymous Try this as a "Custom Column" in "Power Query Editor"
=Text.Combine({"https://welcome/{", Text.From([ID], "en-GB"), "}"})What is "en-GB"
=Text.Combine({"https://welcome/{", Text.From([ID], "en-GB"), "}"})
