Add Columns from two table with inactive relationship

[Student1]

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.

Thanks

Sample file

[johnt75 · Accepted solution]

You could add a new table like

Combined table =
GENERATE(
	'Table1',
	SELECTCOLUMNS(
		FILTER( 'Table2', 'Table2'[Zip Code] = 'Table1'[Zip Code] ),
		"State", 'Table2'[State],
		"Country", 'Table2'[Country]
	)
)

[Student1]

Thank you very much.