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

[jneuey5]

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?

[johnt75]

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

[jneuey5]

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

[johnt75 · Accepted solution]

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
    )