cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SantoshKumar Regular Visitor
Regular Visitor

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 with value as 1234567 and "text" is supplied value as above mentioned.

 

 

Please help on it.

 

Thanks

Santosh 

1 ACCEPTED SOLUTION

Accepted Solutions
affan Established Member
Established Member

Re: Add new Column with some text plus one column data

Hi @SantoshKumar

 

Use the below shown concatenate to create a column also shown below.

NewColumn = CONCATENATE("https://microsoft.visualstudio.com/xxxxx/xxxx",Table2[Column2])

 

Concatenate simple.gif

 

 

 

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

 

Regards,

Affan

4 REPLIES 4
affan Established Member
Established Member

Re: Add new Column with some text plus one column data

Hi @SantoshKumar

 

Are you also having the "Text" and ABC both available in separate columns?

Highlighted
SantoshKumar Regular Visitor
Regular Visitor

Re: Add new Column with some text plus one column data

Hi @affan

ABC is available in a column and i am supplying Text (Text does not available in any column)

 

thanks

Santosh

affan Established Member
Established Member

Re: Add new Column with some text plus one column data

Hi @SantoshKumar

 

Use the below shown concatenate to create a column also shown below.

NewColumn = CONCATENATE("https://microsoft.visualstudio.com/xxxxx/xxxx",Table2[Column2])

 

Concatenate simple.gif

 

 

 

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

 

Regards,

Affan

SantoshKumar Regular Visitor
Regular Visitor

Re: Add new Column with some text plus one column data

Hi @affan

 

Thank you very much.

 

Santosh

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 335 members 4,149 guests
Please welcome our newest community members: