Forum Discussion

Fraze's avatar
Fraze
Icon for Helper I rankHelper I
4 years ago
Solved

Using previous row in current row calculation

Hello, trying to create an outstanding column using data from the previous row.   See example below for situation.   ID #1 has no previous data, so the outstanding balance is the Net change of $1...
Need Help
Tips and Tricks
  • smpa01's avatar
    smpa01
    4 years ago

    Fraze  can you try this

    Column = SUMX (
    FILTER (
        'Table',
        'Table'[Date] <= EARLIER ( 'Table'[Date] )
            && 'Table'[Customer] = EARLIER ( 'Table'[Customer] )
    ),
    'Table'[Net Change]
)

     

     

  • Fraze's avatar
    Fraze
    Icon for Helper I rankHelper I
    4 years ago

    Good idea. But rather than extrapolating the cumultive totals, i need to create the cumulative totals by customer. Creating an index would not work because it would only match the previous value, rather than the cumulative previous values. happy to be wrong though if I am not seeing something