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} ...
Anonymous Try this as a "Custom Column" in "Power Query Editor"
=Text.Combine({"https://welcome/{", Text.From([ID], "en-GB"), "}"})
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"), "}"})