The Missing Donation Receipts: Using a Power Query Anti-Join against Multiple Records and Criteria

This is real!
A non-profit needs to determine which tax receipts have NOT been issued. This is easy to figure out if each donor made one donation. But it’s harder when:
– The same person donates multiple times AND
– They donate the same amount multiple times.

Anne donated $150, $150 and $95.
Her receipt for $150 went out. A simple Anti-Join won’t find the second donation of $150.

In this video we use Get and Transform’s (Power Query’s) Anti-Join in a special way to dig out all donation receipts that still need to be issued.

Website: http://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *