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])
    )
)

     

     

     

     

jdbuchanan71's avatar
jdbuchanan71
Super User
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])
    )
)

 

 

 

 

duycao's avatar
duycao
Frequent Visitor
6 years ago

Hi there, this works perfectly. Thank you!