Forum Discussion
Helper IDax to lookup from multiple values
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
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
2 Replies
NFI27To 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-msftMicrosoft Employee
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