Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create a table using latest available value

Hello everyone! I have two tables one is factual and the other is dimensional and I need to create a relationship based on the "Dojo" where the employees worked. In this scenario My dimension (Latest...
Need Help
Show and Tell
Tips and Tricks
  • Padycosmos's avatar
    Padycosmos
    3 years ago

    Hope this helps:  However, in your data 

    Employee IDLatest Dojo WorkedLatest Date Available
    2233Mcdojo29-Jan-23 ------> this is incorrect the latest is 5-Feb-23
    1122Mcppato12-Feb-23 

     

     

     

  • Padycosmos's avatar
    Padycosmos
    3 years ago

    Instead of MAX(), you may use MIN()

Anonymous's avatar
Anonymous
Not applicable
3 years ago

It worked ðŸ˜„ thanks, how would I do the Opposite? Creating the table with the earliset result found for each employee based on date? 

Thanks in advance

Padycosmos's avatar
Padycosmos
Icon for Solution Sage rankSolution Sage
3 years ago

Instead of MAX(), you may use MIN()