Write latest value to previous dates

[Anonymous]

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

[Zubair_Muhammad · Accepted solution]

@Anonymous 

Try this

=
MAXX (
    TOPN (
        1,
        CALCULATETABLE ( Table1, ALLEXCEPT ( Table1, Table1[KPI] ) ),
        [Date], DESC
    ),
    [KPI_Status]
)