How to get the previous "position" and "department" for the employee

Hi Everyone!

I am trying to make a report relating to getting the employee's current assignment details and their previous assignment details in the organization. We usually used to get the current department and the position in the BI query but how can we achieve this?

My Other consideration was with the "dates" from the assignment table but which became unsuccessful.

The requirements are as follows:

     PERSON_NUMBER               CURRENT_DEPARTMENT              PREVIOUS_DEPARTMENT             CURRENT_POSITION                PREVIOUS_POSITION

I wanted to know if there was any other proper way to Query the following.

Regards,

Partha