Ken Puls ExcelGuru Challenge: Isolate Members and Memberships

/in /by

Recently, Ken Puls of ExcelGuru.ca issued a challenge:
Isolate the members who have more than one type of membership and show all of their transactions.

This was tricky for a few reasons:
– One person had 2 transactions but for the same type of membership. We DON’T want that person in the final list.
– One person had 4 transactions for 3 types of memberships. We want to show all 4 transactions

This video shows my solution. You’ll see GroupBy, a Left Outer Join, and evvythang!

#ExcelChallenge
#GroupingInPowerQuery
#PowerQueryGroupBy

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
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2