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
Highlighted
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

View solution in original post

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?

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

Highlighted
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

View solution in original post

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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and 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.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 2,991 guests
Please welcome our newest community members: