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 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is 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
If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!
Check out the July 2026 Power BI update to learn about new features.