Forum Discussion

duycao's avatar
duycao
Frequent Visitor
6 years ago
Solved

Combine column value from multiple table

Hi there,   I'm seeking your help on how we can creating a new column that combines value from multiple columns from different tables. In particular, I have at least 2 tables, for example   Tabl...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    Hello duycao 

    You can create a calcualted table that give you the unique list from both tables like so.

     

    Combined Table = 
DISTINCT(
    UNION(
        DISTINCT(Table1[Customer Name]),
        DISTINCT(Table2[Customer Name])
    )
)

     

     

    You can continue to add the additional source tables in this one calculation.

     

    Combined Table = 
DISTINCT(
    UNION(
        DISTINCT(Table1[Customer Name]),
        DISTINCT(Table2[Customer Name]),
        DISTINCT(Table3[Customer Name]),
        DISTINCT(Table4[Customer Name]),
        DISTINCT(Table5[Customer Name])
    )
)

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago
The ID fields are the same in both tables? And I understand you want to do it in Power Query?

Best
D