Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
=Table.FromColumns({List.Distinct(List.Intersect({Table1[col],Table2[col]}))},{"Result"})
thank you!
=Table.FromColumns({List.Distinct(List.Intersect({Table1[col],Table2[col]}))},{"Result"})
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.