Forum Discussion
Concatenate URL in Power Query
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 , 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]})
Hi Amit getting the following error...see images
image 2
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.
HI Amit..... is the question do able https://community.powerbi.com/t5/Desktop/TRICKY-Rolling-12-Months/m-p/1969830#M746142