Forum Discussion

Solle's avatar
Solle
Icon for Helper III rankHelper III
3 years ago

Cumulative sum on summarize table

Hi All,  I have a summarize function from the below code: VAR v1 = SUMMARIZE( FILTER( FactSales, FactSales[AsOfDate] = CALCULATE(MAX(FactSales[AsOfDate]), ALL(DimDate)) ...
cumulative
DAX
SUMMARIZE
andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

Try this:

Measure = 
 VAR _Currentyear = SELECTEDVALUE('sales'[Year])
 RETURN IF(HASONEFILTER(sales[Year]),sumx(FILTER(ALLSELECTED('sales'),'sales'[Year]<=_Currentyear),'sales'[Last Sales]),sum(sales[Last Sales]))

 


 

 
 
  • Solle's avatar
    Solle
    Icon for Helper III rankHelper III
    3 years ago

    Hi andhiii079845 
    Thank you for taking your time to respond. I have jut tried your code, but as my summarize code didnt show properly, I am unfortunate that your code snippet does not work, do you have any better suggestion? 

    Best Regards,
    Solle