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
3 years ago

Hi,

Share the download link of the working Excel file which you showed on Sunday.  I need to check something in the formulas there.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    I really do not understand.  How have you got the figure of 8613088 in the visual - in the Table, the figue for July is 7849667.  What is the logic of picking up the budgeted sales figures?  Is it that when the AR value is 0, then tak the budgeted sales figure?  Please give a proper explanation rather than leaving thing to mere guess work.