Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
mhdilyas2008
Frequent Visitor

new table copy specific column from multiple table

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 :

 Table1Table2Table3
 column1column2column3
 name1name7name1
 name2name8name2
 name3name3name3
 name4name4name9
 name5name5name5
 name6name6name10
    
    
    
 newtable  
 name1  
 name2  
 name3  
 name4  
 name5  
 name6  
 name7  
 name8  
 name9  
 name10  
1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community Support

Hi, @mhdilyas2008 

 

You can try the following methods.

Table = DISTINCT(UNION(Table1,Table2,Table3))

vzhangti_0-1689565429653.png

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.

View solution in original post

3 REPLIES 3
v-zhangti
Community Support
Community Support

Hi, @mhdilyas2008 

 

You can try the following methods.

Table = DISTINCT(UNION(Table1,Table2,Table3))

vzhangti_0-1689565429653.png

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.

amitchandak
Super User
Super User

@mhdilyas2008 ,  Try a new table like

new table= distinct(union(distinct(Table1[column]),distinct(Table2[column]),distinct(Table3[column])))

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Tried but receive below error

mhdilyas2008_0-1689003466519.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.