Forum Discussion
NFI27
Helper I
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 pro...
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
NFI27Helper I
Helper ITo 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
Microsoft Employee
Microsoft EmployeeHi 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