Merge Five and more dataset to create one single dataset

[Sam2209]

this is sample table: 

I have four different tables: 

City                        ID 2015

Jaipur	4
tripura	5
Frankfurt	7

City           ID 2016

Jaipur	5
tripura	6
berlin	7

City           ID 2017

Jaipur	7
grt	4
raipur	7

City ID            2018

Bremen	5
Leipzig	7
Freiberg	9

I have to merge and create a single table like this : 

City                        ID 2015    ID 2016   ID 2017    ID 2018

Newyork	4	5	7
Tokyo	5	6	7
Frankfurt	7
Berlin		7
Milan			4
Bremen				5
Leipzig				7
Dresden				9

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

It is for creating a new table.

New Table = 
ADDCOLUMNS (
    SUMMARIZE ( UNION ( Table1, Table2, Table3, Table4 ), [City] ),
    "@2015", CALCULATE ( SUM ( Table1[2015] ), Table1[City] = EARLIER ( [City] ) ),
    "@2016", CALCULATE ( SUM ( Table2[2016] ), Table2[City] = EARLIER ( [City] ) ),
    "@2017", CALCULATE ( SUM ( Table3[2017] ), Table3[City] = EARLIER ( [City] ) ),
    "@2018", CALCULATE ( SUM ( Table4[2018] ), Table4[City] = EARLIER ( [City] ) )
)

[mh2587]

First combine two tables after that then combine the merged tables hope this worked

[mh2587]

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

[Sam2209]

Thanks for reply. 

But in merge queries, i can combine only two tables.

How to combine multiple tables?