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
mahoneypat
Microsoft Employee
Microsoft EmployeeWhat I provided was a measure expression. To use it in a column, wrap the whole expression in CALCULATE( ).
Regards,
Pat
mahoneypat
That was the trick, thank you, that works perfectly!I did come up with an alternative solultion by using this code and just filter on 1 for any calculation