Power Query Innerjoin Distinct Values from Two Columns From Two Tables in One Step

[Anonymous]

Hello Power-Query Community, 

I want to innerjoin the distinct values from two columns from two tables (queries) in one single step in Power Query as a new table (query). Can this be done?

Table 1

Target Column	Random Column 1	Random Column 2
1	d	b
1	q	d
2	b	d
2	d	b

Table 2

Target Column	Random Column 1	Random Column 2
1	f	h
1	k	e
2	g	f
2	g	h
3	w	r
3	f	v

Expected Results Table

Result Column

1

2

I already tried something like:

= Table.Join(
    Table.Distinct(Table1,{"TargetColumn"}),
    Table.Distinct(Table2,{"TargetColumn"}),
    "Expected Results Table",
    JoinKind.InnerJoin
)

Can someone guide me into the right direction?

Many thanks in advance.

[Anonymous]

thank you! 

[wdx223_Daniel · Accepted solution]

=Table.FromColumns({List.Distinct(List.Intersect({Table1[col],Table2[col]}))},{"Result"})