Reconciling Christmas Payments 2: Merging a Table with Itself

In the previous video I showed how to reconcile Christmas payments between 3 siblings. It seemed that classic Excel using SUMIFS was a better solution that Power Query. However, after posting the video, Miguel Escobar offered a simple Power Query solution. But it’s tricky. It involves merging a table with itself and criss-crossing the fields.

The benefit is this solution can include other people.

There’s also a warning in this video because, in Power Query, null is not treated the same as 0.

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2