Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
Good morning everyone,
Apologies in advance if this has been answered elsewhere, I've tried to look through previous threads and figure this out myself but to no avail. I am looking to try and merge the following:
My aim is to align matching values whilst maintaining each column in ascending order. Where there is no match on either data set a blank/null cell is inserted. As shown below:
I've tried a 'Full Outer Join Kind' but it just throws out a load of duplicates.
Many thanks in advance
Hi,
Add index on each table with Table.Group and Join
= Table.Join(
Table.Combine(
Table.Group(
Table1,
{"Value 1"},
{{"Data", each Table.AddIndexColumn(_,"Index 1")}})
[Data]),
{"Value 1", "Index 1"},
Table.Combine(
Table.Group(
Source2,
{"Value 2"},
{{"Data", each Table.AddIndexColumn(_,"Index 2")}})
[Data]),
{"Value 2", "Index 2"},
JoinKind.FullOuter
)
Stéphane
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 8 | |
| 5 | |
| 5 | |
| 4 | |
| 4 |