Forum Discussion

KRISHP1234's avatar
KRISHP1234
Icon for Helper I rankHelper I
2 years ago
Solved

Calculate Cumulative sum

 
  • vivek31's avatar
    vivek31
    2 years ago

    Hi 

    KRISHP1234 

     

    you can try same function to solve your problem.

     

    example;

    cumulative total = CALCULATE([total gross sales],
                           FILTER(ALLSELECTED('MTD,QTD,YTD'),'MTD,QTD,YTD'[Sales Date] 
                           <= MAX('MTD,QTD,YTD'[Sales Date])))

vivek31's avatar
vivek31
Icon for Resolver II rankResolver II
2 years ago

Hi 

KRISHP1234 

 

you can try same function to solve your problem.

 

example;

cumulative total = CALCULATE([total gross sales],
                           FILTER(ALLSELECTED('MTD,QTD,YTD'),'MTD,QTD,YTD'[Sales Date] 
                           <= MAX('MTD,QTD,YTD'[Sales Date])))