How to create a new table with columns from two different tables based on dates?

[scorbin]

I have two tables with dates in a certain range and some time data. One column in hours and the other in seconds and the third the "area". The dates aren't exactly one to one with about an extra day one either side on one of the tables. How would I go about creating a new table with one date column made up of the dates from both tables, and then two columns for the time data from each table?

The tables look something like this: 

Table 1: 

Column3 = Hours

 Table 2:

Column 3 = seconds

I would want a new table like this

Column 3 = hours, column4 = seconds:

[scorbin]

Alright, I think I figured out. I appended the tables then removed any columns that I didn't need, leaving the date column, area column, and two time columns. After that I used the SUMMARIZE table function like this: 

SUMMARIZETable =
      SUMMARIZE(
               AppendTable
              ,AppendTable[Date]
              ,AppendTable[Area]
              ,"Total Hours 1"
               ,SUM(
                    AppendTable[Hours 1])
               ,"Total Hours 2"
              ,SUM(
                  AppendTable[Seconds 1]) / 3600)

And that got me my new table with summed amounts based on date and area, which I could now create measures one and whatever else. 

[amitchandak · Accepted solution]

@scorbin , TRy merge in power query

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

or natural joins in dax

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

[scorbin]

The append and merge seems to almost be what I need. However, I think I didn't provide enough info originally. The two tables have extra columns that don't match, and I was hoping to basically sum the two number columns based on the date and area columns from the original tables. Is there a way to select which columns are brought over to the new table? And would it be possible to sum the number columns based on the other two columns that do match, i.e. sum based on date and area?