Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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 |
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |