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...
Need Help
  • AntonioM's avatar
    AntonioM
    4 years ago

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

     

     

AntonioM's avatar
AntonioM
Solution Sage
4 years ago

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

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks, it worked!