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

zbikra's avatar
zbikra
Frequent Visitor
6 months ago

Hi;

My problem is a very closed I've find on diff forums, but not exactly the same. So:

 

I want to calculate [start current daily stock] with the formula: 

[start current daily stock] of the current day = [start current daily stock] of the previous day + [delivery] of the previous day - [daily consumption] of the previous day.

Please note that the value of [start current daily stock] for Today comes from an another source, so it's not calculated with the formula than further days.

Does Anybody to help me to solve my problem ? 

Thx very mych in advance.

  • zbikra's avatar
    zbikra
    Frequent Visitor
    6 months ago

    Hello Ashish,

    Thanks very much for your help. It's just I'm looking for !

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      6 months ago

      You are welcome.