Write latest value to previous dates

Hi!

I have been grinding on this one for a while and was hoping someone here has solved a similiar issue (or are smart enough to solve it!). I need to write a value to a previous row based on the current value:

I have a case where I would like to write a current KPI status to a a column with the current value to be added to all earlier values.

Example:

Date | KPI | KPI_Status | *Latest_KPI_Status*

01.01.2019 | 1 | 1 | 2

01.02.2019 | 1 | 2 | 2

01.01.2019 | 2 | 2 | 1

01.02.2019 | 2 | 2 | 1

01.03.2019 | 2 | 1 | 1 

Some of these values I get from measures and custom columns that are available in my sample set: 

https://1drv.ms/f/s!Au2BC7WA4ot_gcQRJmPco_nwBx1iZw

Thank you in advance! :)

Best regards

arefossa