Forum Discussion
How to combine multiple table to one?
Hi All, I have 3 table each of them with a field "AssectName". I would like to combine all 3 fields from 3 different table to one field on a new table (without having any duplicate values). H...
Hi, Anonymous
Please correct me if I wrongly understand your question.
I assume that you want to create a one-column table that combines three AssectName columns from three table, and removes duplicates.
Please try the below for creating a new table.
newtable =
SUMMARIZE (
UNION ( VALUES ( 'Table1'[AssectName] ), VALUES ( 'Table2'[AssectName] ) ),
[AssectName]
)Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
ty