Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Iterate with LOOKUPVALUE

Hello all, I have been stuck on this for the whole afternoon, I feel like I'm just missing something...   I manage an email app data and have 3 tables:    Main Table listing all events occurence...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hey ChrisMendoza,

     

    Thanks for your answer, yes it is pretty much what I was looking for

     

    I understood where I went wrong: I had duplicate values in the Search column.... So obvious...

     

    The result I was looking for:

     

    Original Email Received Date = 
    LOOKUPVALUE( 
        'receive tab'[Date];
        'receive tab'[Message ID];
        'send tab'[In Reply To];
        'receive tab'[Email];
        'send tab'[Email] 

    )

     

    Thanks again Chris, idk how I struggled for 3 hours... 

     

    Best,

    L

ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
8 years ago

Anonymous,

 

Is your expected outcome for your example tables below?:

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hey ChrisMendoza,

     

    Thanks for your answer, yes it is pretty much what I was looking for

     

    I understood where I went wrong: I had duplicate values in the Search column.... So obvious...

     

    The result I was looking for:

     

    Original Email Received Date = 
    LOOKUPVALUE( 
        'receive tab'[Date];
        'receive tab'[Message ID];
        'send tab'[In Reply To];
        'receive tab'[Email];
        'send tab'[Email] 

    )

     

    Thanks again Chris, idk how I struggled for 3 hours... 

     

    Best,

    L

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      8 years ago

      Hi Anonymous,

       

      Have you solved your problem?

       

      If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

       

      Best  Regards,

      Cherry