Forum Discussion
Cumulative sum by condition and by date
I need that when 'operation_external_id' = "602" appears on the timeline, that 'total_costs' accumulate considering 'calendar_date' and 'project_id'. I need a sum conditioned on two variables: 1s...
andersonramos
Can you show us how does it look like after using the formula?
And It is appreciated if you can show your the your expected result in a table view, or just provide your pbix after removing sensitive infomation.
Best,
Paul
Of course, thanks for your interest
Follow link below:
https://docs.google.com/spreadsheets/d/19Vy6tx7RQzEmiLG1-CHYVwS2lUGGcQvpi6wvHghXZcI/edit?usp=sharing
I also have the pbix if needed.
Cumulative total = CALCULATE ( SUM ( 'Table'[total_costs] ), FILTER ( ALLEXCEPT ( 'Table', 'Table'[stand_id] ), [calendar_date] < EARLIER ( 'Table'[calendar_date] ) ) )