How to refer to the previous row?

[Qazybek]

Dear friends,

How can I refer to the previous row in Power BI this way?

Thank you

[Chihiro · Accepted solution]

If doing in DAX Calculated column, something like below.

Column =
VAR calc =
    CALCULATE (
        MAX ( [Amount] ),
        FILTER ( Table, [Index] = ( EARLIER ( [Index] ) - 1 ) )
    )
        * (
            1
                + CALCULATE (
                    MAX ( [Rate] ),
                    FILTER ( Table, [Index] = ( EARLIER ( [Index] ) - 1 ) )
                )
        )
RETURN
    IF ( ISBLANK ( calc ), 1000, calc )

[Anonymous]

https://community.powerbi.com/t5/Desktop/reference-Previous-row-using-measures/m-p/725894#M350298

help me out on this.

[Qazybek]

Hi @Chihiro,

Thank you for your answer. Is it possible to write the formula inside "Amount" column in DAX?

[Chihiro]

Can't think of way to do it in DAX.

Let me think on it.

[Chihiro]

Depends on where you want to do the calculation.

In Query Editor ("M"): Replace #"PreviousStep" with acutal previous step name

= try #"PreviousStep"{[Index]-2}[Amount] * (1 + #"PreviousStep"{[Index]-2}[Rate]) otherwise 1000

Since row index is 0 based, and your index column is 1 based, you'd subtract 2 from index column value to obtain row index of previous row.