get value from Previous row

[Rigoleto]

Need a funtion or logic to read a previous row, for instance:

 

How can you see Do I need is to sum up the previos record and build a new column with those values

Appreciate your help!!

[Anonymous]

Hi,

I am really sorry for the inconvenience that occurred. Just forget about the first dataset I shared. In my previous email, I shared a Google sheet link with the dataset. Hope that would be helpful.

[Ashish_Mathur]

I still do n ot understand at all.  Sorry.

[Zubair_Muhammad · Accepted solution]

@Rigoleto

I think this calculated column would work.

See the attached sample file as well

Calculated Column =
VAR PreviousRow =
    TOPN (
        1,
        FILTER (
            Table1,
            Table1[Month] < EARLIER ( Table1[Month] )
                && Table1[Employee] = EARLIER ( Table1[Employee] )
        ),
        [Month], DESC
    )
VAR PreviousValue =
    MINX ( PreviousRow, [Sales] )
RETURN
    Table1[Sales] + PreviousValue

[Csaba]

Great solution, thank you @Rigoleto!

[Kamill11]

@Zubair_Muhammad 

Can we easly rebuilt this to get value from FIRST existing row? I tried by MIN etc. in my case i have date, not only month. SO i want get value with first date. 

[rrathod]

@Zubair_Muhammad  Thank you so much !

[Zubair_Muhammad]

@Rigoleto

Try this Column

Column =
VAR PreviousRow =
    TOPN (
        1,
        FILTER ( Table1, Table1[Column A] < EARLIER ( Table1[Column A] ) ),
        [Column A], DESC
    )
VAR PreviousValue =
    MINX ( PreviousRow, [Column B] )
RETURN
    Table1[Column B] + PreviousValue