Forum Discussion
SantoshKumar
7 years agoMicrosoft Employee
Add new Column with some text plus one column data
Hi, i need to create a new column which should be a combination as below: Column1 = https://microsoft.visualstudio.com/xxxx/xxx/xxx/1234567 Column1 = "Text"+ABC where ABC is an existing column wit...
- 7 years ago
Hi SantoshKumar
Use the below shown concatenate to create a column also shown below.
NewColumn = CONCATENATE("https://microsoft.visualstudio.com/xxxxx/xxxx",Table2[Column2])If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Regards,
Affan
affan
7 years agoSolution Sage
Hi SantoshKumar
Use the below shown concatenate to create a column also shown below.
NewColumn = CONCATENATE("https://microsoft.visualstudio.com/xxxxx/xxxx",Table2[Column2])
If this helped you, please mark this post as an accepted solution and like to give KUDOS .
Regards,
Affan
SantoshKumar
7 years agoMicrosoft Employee