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: [ Ссылка ]
My book: Guerrilla Data Analysis 2nd Edition
[ Ссылка ]
My old blog: [ Ссылка ]
