need help: want to find all items that are not in a list for a specific date

[SebastianAlmer]

Dear all,

I'd kindly ask for your help, cause I really have no idea how to solve that.

I have two tables where I'd like to find all items for a specific date that are *not* in the table.

Personnel:

Projects:

I want to have a list with all people *not* working on a specific date.

So one option would be to have a resulting list like this:

or of course only the empty items (but this i can achive easy based on the last list):

Date	PNR
02.01.2021	2
03.01.2021	2
03.01.2021	3

Any idea how to solve this and to get to the third combined list?

thanks in advance

regards

Sebastian

[SebastianAlmer]

Thanks @amitchandak 

One more question: How would i do that to antoher table where i have an inactive relationship? how could I add USERLATIONSHIP there?

[amitchandak]

@SebastianAlmer , yes create a measure with userelationship and check for blank for the complete measure with userelationship

[amitchandak · Accepted solution]

@SebastianAlmer ,I am assuming both tables are join

use this measure  with first name , last name or any column with Personnel table

if(isblank(count(Project[project])),1,0)