Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!