Forum Discussion

IntaBruce's avatar
IntaBruce
Icon for Resolver I rankResolver I
1 year ago
Solved

LOOKUPVALUE with multiple results

Hi, I am using LOOKUPVALUE to find the staff member associated with a particular record.  However, the table containing the information has multiple records for different dates.  In other words, one...
Need Help
  • IntaBruce's avatar
    IntaBruce
    1 year ago

    Sorry lbendlin, I have confused matters by misunderstanding the data myself.  After consulting with the developers who support the source database they have confirmed that the dates are a red herring as there will only ever be one record but that it has to match not just the related work order record but also met be of the correct assignment type and also be the Primary record.
    so, my final formula is:

    Assigned Staff = LOOKUPVALUE(AssignedStaff[Staff Name],AssignedStaff[Record_UID],[UID],AssignedStaff[StaffAssignmentType],1,AssignedStaff[IsPrimary],TRUE())
     
    Thank you for your time and efforts in helping me solve my problem.  Kudos given 🙂
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago
the one with the most recently created/modified entry in the AssignedStaff table.

you lost me on this one.  which date do you want to sort by, created or modified?

IntaBruce's avatar
IntaBruce
Icon for Resolver I rankResolver I
1 year ago

Sorry lbendlin, I have confused matters by misunderstanding the data myself.  After consulting with the developers who support the source database they have confirmed that the dates are a red herring as there will only ever be one record but that it has to match not just the related work order record but also met be of the correct assignment type and also be the Primary record.
so, my final formula is:

Assigned Staff = LOOKUPVALUE(AssignedStaff[Staff Name],AssignedStaff[Record_UID],[UID],AssignedStaff[StaffAssignmentType],1,AssignedStaff[IsPrimary],TRUE())
 
Thank you for your time and efforts in helping me solve my problem.  Kudos given 🙂