Add Columns from two table with inactive relationship

Hiya,

I am connected to two tables via direct query, and both contain some geographic data. Below sample screenshot shows the tables:

also, the model is simple like the below:

My ask is to create a new virtual table with DAX (not PQ), where Table1[zip code] = Tbale2[zip code] and return these columns:
City, lat, long, zip, State and country.

Any help is relayy appreciated. Thanks.
Thanks

Sample file