Forum Discussion

Student1's avatar
Student1
New Member
3 years ago
Solved

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:   ...
  • johnt75's avatar
    johnt75
    3 years ago

    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]
	)
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

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's avatar
Student1
New Member
3 years ago

Thank you very much.