Forum Discussion

v-amarsh's avatar
v-amarsh
Microsoft Employee
6 years ago

Cumulative sum

Hi Community, I am trying to get a running total on a field based on condition on a different column. Below is my input table along with expected output column (Cumulative Assigned)to produce . Col...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

I don't see anything where you have a sortable column that would allow you to define "previous". If you had that, you could do something like this:

 

Column =
  SUMX(
    FILTER(
      'Table',
      [GSI Name] = EARLIER('Table'[GSI Name]) && 
        [GD SI Role] = EARLIER([GD SI Role]) && 
          [Some field] <= EARLIER([Some field])
    ),
    [Plan Assigned]
  )