Forum Discussion

Rigoleto's avatar
Rigoleto
Helper II
8 years ago
Solved

get value from Previous row

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 Ap...
Tips and Tricks
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Please share a meaningful dataset.  While your column title is month, entries under that column are Sales 1, Sales 2.  I am sure there are months/dates in that column.  Please share a meaningful dataset with column names and data therein making sense so that i can frame a solution.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
    Ashish_Mathur
    Super User
    3 years ago

    I still do n ot understand at all.  Sorry.