Forum Discussion
Concatenate URL in Power Query
Hi Experts
I am trying to concatenate the following URL with the [ID] Column in my table in Poqwer Query
https://XXX.sharepoint.com/sites/XXX/Lists/LISTNAME/DispForm.aspx?ID
Anonymous , In case you are trying to create a new column
New column = "https://XXX.sharepoint.com/sites/XXX/Lists/LISTNAME/DispForm.aspx?" & [ID]
or
New column = Text.Combine({"https://XXX.sharepoint.com/sites/XXX/Lists/LISTNAME/DispForm.aspx?" ,[ID]})
5 Replies
Anonymous , In case you are trying to create a new column
New column = "https://XXX.sharepoint.com/sites/XXX/Lists/LISTNAME/DispForm.aspx?" & [ID]
or
New column = Text.Combine({"https://XXX.sharepoint.com/sites/XXX/Lists/LISTNAME/DispForm.aspx?" ,[ID]})
Thanks Amit....
Can you shed some light on https://community.powerbi.com/t5/Desktop/TRICKY-Rolling-12-Months/m-p/1969830#M746142
Anonymous , Sure, I will have look.