Quick Tip: Find The Missing (Data) Links
This QuickTip offers a quick use-case for PowerQuery's Merge command to connect data together in order to locate potential missing pieces.
In this QuickTip, Philip takes an invitation list and constructs a series of reports to identify who has responded, how they have responded, along with identifying who has not responded and if any improper responses have been received or otherwise keyed wrong using a series of outer and anti joins.
You can find our introductory and advanced PowerQuery courses through Udemy.
Image Credits:Aaron Burden