Forum Discussion

jneuey5's avatar
jneuey5
Frequent Visitor
3 years ago
Solved

LOOKUPVALUE to pull date from a column based on text from another column

Hi, 


I have a table with multiple entries for each person depending on the step in the process. I'm looking to pull those dates from the other rows into one row. I've been trying RequestSentDate = LOOKUPVALUE(Sheet1[Activity Date],Sheet1[Activity],"REQUEST SENT") but am getting A table of multiple values was supplied where a single value was expected. error. I'm not sure what I'm missing, any ideas?

DAX
  • johnt75's avatar
    johnt75
    3 years ago

    If the column was called Person ID then it would be

    RequestSentDate =
VAR CurrentPerson = Sheet1[Person ID]
RETURN
    LOOKUPVALUE (
        Sheet1[Activity Date],
        Sheet1[Activity], "REQUEST SENT",
        Sheet1[Person ID], CurrentPerson
    )

3 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    You need to include the unique identifier for the person in the LOOKUPVALUE

    • jneuey5's avatar
      jneuey5
      Frequent Visitor
      3 years ago

      Apologies, where would that go in the string? I tried it in a variety of spots with no luck

      • johnt75's avatar
        johnt75
        Icon for Super User rankSuper User
        3 years ago

        If the column was called Person ID then it would be

        RequestSentDate =
VAR CurrentPerson = Sheet1[Person ID]
RETURN
    LOOKUPVALUE (
        Sheet1[Activity Date],
        Sheet1[Activity], "REQUEST SENT",
        Sheet1[Person ID], CurrentPerson
    )