How to combine 2 tables into one?

[bourne2000]

Hi

I have two tables, table 1 and table 2. Both the tables have been connect with street address and it is many to many relationship

In table 1, it doesn't have a date. I need to create a single map by taking both tables. So I want to combine both these tables into one table. How to do it?

I can create a map separately for each graph, but needs to create one map for both. 

[Anonymous · Accepted solution]

HI @bourne2000,

I'd like to suggest you take a look at the following link about creating a bridge table and many column relationships.

How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive

Relationship in Power BI with Multiple Columns - RADACAD

After you build a relationships bridge based on many columns, you can create a calculated table to use one table as the base and relationships key as conditions to lookup and summary another table records.

Regards,

Xiaoxin Sheng

[amitchandak]

@bourne2000 , Create combine field using log/Lat and sqft if needed and merge

In power power and merge

new column = [longitude] & "-" & [Latitude]

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

Or create a new column  in a table 

Date in tbale 1 = maxx(Table2, Table2[longitude] = Table1[longitude]  && Table2[Latitude] = Table1[Latitude] ), Table2[Date])

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8