Forum Discussion
duycao
6 years agoFrequent Visitor
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...
- 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
6 years agoFrequent Visitor
Hi there, this works perfectly. Thank you!
Anonymous
6 years agoNot applicable
Hi duycao ,
If your problem has been resolved, could you please mark the helpful post as Answered? It will help anyone in the community find the solution easily if they face the same problem with you. Thank you.
Best Regards
Rena