Forum Discussion

SantoshKumar's avatar
SantoshKumar
Microsoft Employee
7 years ago
Solved

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...
  • affan's avatar
    affan
    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