How to set up a calculated column to write back a date from another row and count during these dates

Hi all,

i am working on a problem in Power BI and could not solve it.

I have a table with Dates, Names of Employees and Status of these employees. Also, there is a Column with the previous Status of that employee and the NextStatus. My raw data and the 2 columns i wanted looks like this:

I managed via calculated column to generate the column "K start": 

K Start= 
VAR Date_K_Start = 
    IF(
        AND([Status] = "K", [PrivStatus] <> "K"),
        [Date],
        BLANK()
    )
RETURN
    FORMAT(Date_K_Start, "DD.MM.YYYY")

The same i used to get the column K end:

K end = 
VAR Date_K_end= 
    IF(
        AND([Status] <> "K", [PrivStatus] = "K"),
        [Date],
        BLANK()
    )
RETURN
    FORMAT(Date_K_end, "DD.MM.YYYY")

But of course K end goes in the wrong row in the Column. My question is how to i get it in the right row (together with the K start). Since there are many Employees in this list, it needs to filter correctly for the same name.

Furthermore: I would like to count how many times "K" in [Status] appears during K start and K end. 

Thanks in advance! 

seppel123