LAG Function not able to pull previous job of an employee.

Hello Experts,

I am creating a report to pull the previous job of an employee, I am using LAG function to fetch the previous job,

but i turns out to fetch the same data

can someone please advise me on how to do it perfectly

thanks, and advance experts.