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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
Anonymous
Not applicable

Combining tables

Dear All,

 

I have three tables as below. 

 

1st table

SRHerath_0-1698982977821.jpeg

 

,   

2nd table

SRHerath_1-1698982990789.jpeg

 

,

3rd table

SRHerath_2-1698983001939.jpeg

 

Is there a way to get these three tables to a one table as below. 

SRHerath_3-1698983016511.jpeg

Thank You.
SRHerath.

1 ACCEPTED SOLUTION
vicky_
Super User
Super User

Hey! Yes there are a few ways, especially if you have access to the raw data.
The easiest way is to use PowerQuery's in-built append queries function to simply merge all your tables. 

vicky__0-1698983788736.png

Otherwise, if you need to create a table with DAX, then you can either create a new table and use the DAX CombinedTable = UNION(Table1, Table2, Table3), 

View solution in original post

3 REPLIES 3
vicky_
Super User
Super User

Hey! Yes there are a few ways, especially if you have access to the raw data.
The easiest way is to use PowerQuery's in-built append queries function to simply merge all your tables. 

vicky__0-1698983788736.png

Otherwise, if you need to create a table with DAX, then you can either create a new table and use the DAX CombinedTable = UNION(Table1, Table2, Table3), 

Anonymous
Not applicable

Thank You @vicky_ . 

No worries, glad to help!

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.