Forum Discussion
Lookup Value from another table based on first date
Hello Community, I am trying to lookup a value in a child table based on the first delivery date. The tricky part of this is that there will be multiple delivery numbers for each distinct value ...
Please try this measure expression, replace Child for your actual child table name.
First Delivery Number = FIRSTNONBLANKVALUE(Child[Delivery Date], MIN(Child[Deliver Number]))
Regards,
Pat
What I provided was a measure expression. To use it in a column, wrap the whole expression in CALCULATE( ).
Regards,
Pat
The green column (Excel) is the field I am refering to from the parent table (PBI).
I want to lookup the delivery number (blue) for only the first delivery created date (Orange) based on the Order shipping point ID (Green).
Lookup in PowerBi should be:
| Order shipping point | First Delivery |
| 7686639 | 3915 | 53190034 |
| 7686339 | 39SP | 53191851 |