how to concatenate two columns from two different tables

[Anonymous]

how to concatenate two columns from two different tables

[JorgePinho · Accepted solution]

Are the tables conectable by any column (for example an ID)?

[v-yueyunzh-msft · Accepted solution]

Hi , @Anonymous 

You can create a calculated column by using LOOKUPVALE() function to get the column from other table if the two table has the related field.

LOOKUPVALUE(the column you want , GroupID column from Table1 ,GroupID column from Table2)

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[JorgePinho · Accepted solution]

Are the tables conectable by any column (for example an ID)?

[Anonymous]

it's having Group Customer ID column

[JorgePinho]

In the Power Query Editor you can use Merge Queries to bring the column you need to the table, conecting them trough that ID. Then you select the two columns you want to merge and use Merge Columns.

[JadhavVarsha_13]

Hello 

You can refer to this - Analytic Pursuits – Analytics Made Easy For Everyone!