Concatenate URL in Power Query

[Anonymous]

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

[amitchandak · Accepted solution]

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

[Anonymous]

Thanks Amit.... 

Can you shed some light on https://community.powerbi.com/t5/Desktop/TRICKY-Rolling-12-Months/m-p/1969830#M746142

[amitchandak]

@Anonymous , Sure, I will have look. 

[Anonymous]

HI Amit..... is the question do able  https://community.powerbi.com/t5/Desktop/TRICKY-Rolling-12-Months/m-p/1969830#M746142

[Anonymous]

Hi Amit getting the following error...see images

image 2