Existing data vs corresponding previous data comparison

Hi,   I am currently working with insurance data where policy gets renewed or new policy is placed. I want to achieve something like this:- There is a policy ABC-2021 which gets renewed and policy...