Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Retrieve from other table

Hello,

 

Let me get straight to the point. I want to retrieve data from another table based on the date.

I have two tables;

 

The first one is as follows: 

 

The second one is as follows: 

So in the column "Result" I want to have the work day of the first table, and this linked by the column "Date" and "maand forecast". 

 

Conclusion: I want work day 18 in my second table whereby the date is linked. 

 

Thanks in advance!

  • Result = LOOKUPVALUE( TABLE1[Work day], TABLE1[Date], TABLE2 [Maand forecast] ) 

     

     

2 Replies

  • AntonioM's avatar
    AntonioM
    Solution Sage

    Result = LOOKUPVALUE( TABLE1[Work day], TABLE1[Date], TABLE2 [Maand forecast] ) 

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks, it worked!