Hi @VishnuCh , At first create a dataset out of base columns and then you can create that calculated column ("Previous Assignment") by using LAG function (call it inside Evaluate function) and put "Assignment end date" in Order by clause. Regards, Abhirup