Forum Discussion

Gaspa25's avatar
Gaspa25
Regular Visitor
1 year ago
Solved

Cumulative sum dynamic

Hi everyone,  I am trying to create a measure that calculates the cumulative sum of a column, I want the cumulative sum to update based on the selected months in my slicer, meaning I want my graph t...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Gaspa25 ,

     

    I missed something in my formulas. Please use these:

     

    2023 YTD = CALCULATE(SUM('RentalAgreement List'[Total R.A]),FILTER(ALLSELECTED('RentalAgreement List'),[sort]<=MAX('Month'[SORT])&&YEAR([Date])=2023))
    2024 YTD = CALCULATE(SUM('RentalAgreement List'[Total R.A]),FILTER(ALLSELECTED('RentalAgreement List'),[sort]<=MAX('Month'[SORT])&&YEAR([Date])=2024))

    Here's the result:

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

vivek31's avatar
vivek31
Icon for Resolver II rankResolver II
1 year ago

HI Gaspa25 ,

you can try this type of measure to find your requirement according cumulative sum.

cumulative sum = CALCULATE(SUM(Sales[SalesAmount]),
                            FILTER(ALLSELECTED('Calendar 2'),
                            'Calendar 2'[DateKey] <= MAX('Calendar 2'[DateKey])))

 

 

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Gaspa25's avatar
Gaspa25
Regular Visitor
1 year ago

Hi, 

Thank you for the help, that code does actually work to measure for current year cumulative sum, I would like to calculate as well the cumulative sum for the sameperiod for last year so that when I select june and july 2024 it also shows june and july 2023, but if i try to do the measure 

ytd test 3 ly = CALCULATE([YTD TEST 3], SAMEPERIODLASTYEAR(DateTable[Date].[Date]))
it only shows the sum per day and not the cumulative, do you know the solution for this one?
thank you in advance