Dax to lookup from multiple values

[NFI27]

Hello,

I am a fairly new user to power bi. i have question regarding the lookup from multiple values. Lets say i have a table named (production) with the items (reference numbers) that are in production and i have another table lets say (entry)with the items (reference number)and entry date to the warehouse.

I want to use the lookup function to find out wich item in the (production) table does not have an entry date in the (entry) table, thus determine that this item is new.

Keep in mind there are multiple values (a lot of repeated reference numbers) in the entry table.

 
I want to use the function to determin which item has never been in the warehouse.

Thanks in advance sorry if this has been said before                                            

[NFI27]

To add on to the explanation:

an example:

If this were two seperate tables how could i use the lookup function to determine that disk is new (given the fact that it has no entry date

ITEM	ENTRY		ITEM	PRODUCTION
Hammer	01/05/2018		hammer	01/09/2018
Drill	02/05/2018		Drill	02/08/2018
Knife	01/06/2018		Disk	NEW
Saw	15/06/2018		Saw	15/06/2018
Drill	02/08/2018		Knife	01/06/2018
Hammer	01/09/2018

[v-cherch-msft · Accepted solution]

Hi @NFI27

You may try below formula:

PRODUCTION =
VAR NewDate =
    CALCULATE (
        MAX ( entry[ENTRY] ),
        FILTER ( entry, entry[ITEM] = production[ITEM] )
    )
RETURN
    IF ( NewDate = BLANK (), "New", NewDate )

Regards,

Cherie