Forum Discussion

jneuey5's avatar
jneuey5
Frequent Visitor
4 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 =...
DAX
  • johnt75's avatar
    johnt75
    4 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
    )
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

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

  • jneuey5's avatar
    jneuey5
    Frequent Visitor
    4 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
      4 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
    )