topic Re: Add Columns from two table with inactive relationship in DAX Commands and Tips

Add Columns from two table with inactive relationship

Student1 — Mon, 20 Feb 2023 14:37:49 GMT

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

Re: Add Columns from two table with inactive relationship

johnt75 — Mon, 20 Feb 2023 14:47:48 GMT

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] ) )

Re: Add Columns from two table with inactive relationship

Student1 — Mon, 20 Feb 2023 15:50:03 GMT

Thank you very much.