Compare Two Table Using Select Statement

[jafferjee]

Scenario:

I have Table A [USERS] with a list of all possible User ID, and Table B [Attendance] with User Id that are already In Table B. I want to find the User ID in Table A that are not yet used in Table B.

ISNOTBLANK(SELECT(
Users[User ID],
Not(IN([User ID], Attendance[User ID]))
)
)

Above Select statement fetch all A Table Records not Skip Table B Records.

I don't know where i am doing wrong please help

[scott192]

SELECT(Users[User ID],TRUE) - INTERSECT(Users[User ID],Attendance[User ID])

This formula compiles all users in the users table first.  Then it subtracts from that list all users that appear in the users table and the attendance table.  It will leave a list of all users who do not have any attendance.

[Marc_Dillon]

Even simpler:

Users[User ID] - Attendance[User ID]

[jafferjee · Accepted solution]

Thank you for your reply, its resolve 

NOT(IN([User ID],SELECT(Attendance[User ID],[DateChk]=TODAY())))

[jafferjee]

Thank you Brother for your mail

[jafferjee]

Thank you for your reply its resolve!

NOT(IN([User ID],SELECT(Attendance[User ID],[DateChk]=TODAY())))