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.
My book: Guerrilla Data Analysis 2nd Edition
My old blog: http://datascopic.net/blog-2-2