Find Missing Dates From Referenced Table

Question

Hello,

I have table which contains Dates

Calender Dates1/1/20201/2/20201/3/20201/4/20201/5/20201/6/20201/7/20201/8/20201/9/20201/10/20201/11/20201/12/2020

I have another table which contains UserID and LogDates

UserIDLog Dates11/1/202011/2/202021/3/202021/4/202021/5/202021/6/202021/7/202021/8/2020

Is there anyway to find the missing Dates By User

Missing dates are those which are not in User Table but present in Referenced Table

For example for user 1 it should be like

UserIDMissingLogDates11/3/202011/4/202011/5/202011/6/202011/7/202011/8/202011/9/202011/10/202011/11/202011/12/2020

BrandonB · Accepted Answer

I would take the entire list of calendar dates that you expect, and the entire list of UserIDs, and append one to the other. This creates a master list of sorts which is the entire list of expected combinations. Then you can join it back to the UserIDs and Log Dates table on both the UserID and log date. The L or R on the side of the master list will show the combinations that do not exist in your main data set which I believe is what you are looking for.