Date calculation

Hi All,

I have a table where a ID can have multiple Since_Date and To_Date. I would like to populate the Max since Date for an employee (in this case it would be 3/1/2017) and the corresponding To_Date (which is Null in this case)

I am trying to use { FIXED [DJ_Id]: MAX([Since_DATE])} however for the corresponding To_Date I am getting wrong results.

what I would like is

ID    Since_Date          To_Date

1.     3/1/2017.     Null

Please suggest. 

Regards,

Rishi