Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
We have imported data from different source and all source have 1 common column.
and we want to create new table and copy data from all source to specific column
Note : i have tried append but im looking for different way.
Example :
Table1 | Table2 | Table3 | |
column1 | column2 | column3 | |
name1 | name7 | name1 | |
name2 | name8 | name2 | |
name3 | name3 | name3 | |
name4 | name4 | name9 | |
name5 | name5 | name5 | |
name6 | name6 | name10 | |
newtable | |||
name1 | |||
name2 | |||
name3 | |||
name4 | |||
name5 | |||
name6 | |||
name7 | |||
name8 | |||
name9 | |||
name10 |
Solved! Go to Solution.
Hi, @mhdilyas2008
You can try the following methods.
Table = DISTINCT(UNION(Table1,Table2,Table3))
Please refer to the attachment.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @mhdilyas2008
You can try the following methods.
Table = DISTINCT(UNION(Table1,Table2,Table3))
Please refer to the attachment.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@mhdilyas2008 , Try a new table like
new table= distinct(union(distinct(Table1[column]),distinct(Table2[column]),distinct(Table3[column])))
Tried but receive below error
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
73 | |
72 | |
38 | |
31 | |
26 |
User | Count |
---|---|
97 | |
87 | |
43 | |
40 | |
35 |