Duplicate Data entries

Hi O-K 

You can get your required output as follows:

1-  I would like to adjust the start date to be the end date of the previous (Latest) one and so.

2- keeping only one Active status per employee (Latest)

In addition to this, you can create a disconnected calendar table to do a flexible headcount analysis, but I didn't create a calendar table in this example. 

I attach an example pbix file.  

Firstly thank you for the quick response.
I somehow keep getting an error in the second half

Hiii Try this DAX
Adjusted Department StartDate =
VAR Departmentstartdate =
CALCULATE(
MAX('EU HR'[Adjusted End/present day]),
FILTER(
'EU HR',
'EU HR'[Adjusted End/present day] < EARLIER('EU HR'[Adjusted End/present day])
)
)
RETURN
IF(
ISBLANK(Departmentstartdate),
'EU HR'[Adjusted End/present day],
Departmentstartdate
)