Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Use previous total with blank cumulative data

I am running aggregate totals based on GL for one of my reports. There is a gap in entries for a few periods where i would like to carry the previous periods amount if there were no transactions that...
Need Help
PabloDeheza's avatar
PabloDeheza
Icon for Solution Sage rankSolution Sage
3 years ago

Hi there!

For cumulative sum you try this:

CALCULATE (
    SUM ( ColumnToSum ),
    FILTER (
        ALL ( DateTable ),
        DateTable[Date] <= MAX ( DateTable[Date] )
    )
)

Let me know if that helps!