Cumulative sum by date and category

Anonymous To get the breakdown that you have in your CUMULATIVE_SUM column you would need an Index which you would then substitute for DATE in this formula:

Cumulative = 
    VAR __Version = [VERSION]
    VAR __Date = [DATE]
    VAR __Table = FILTER( ALL( 'Table' ), [VERSION] = __Version && [DATE] <= __Date )
    VAR __Result = SUMX( __Table, [VALUE] )
RETURN
    __Result

Greg_Deckler

thx for reply,

it worked with follow adjusts:

Cumulative = 
    VAR __Version = SELECTEDVALUE(BASE_TOTAL[VERSAO])
    VAR __Date = SELECTEDVALUE(BASE_TOTAL[SAFRA])
    VAR __Year = YEAR(__Date)
    VAR __Table = FILTER( ALL(BASE_TOTAL), [VERSAO] = __Version && YEAR([SAFRA]) = __Year && [SAFRA] <= __Date )
    VAR __Result = SUMX( __Table, [VALOR] )
RETURN
    __Result

Edit:

I ran into a problem working with the previous dax, my slicers werent filtering my cumulative sum chart, so i made a small adjust again:

Cumulative = 
    VAR __Version = SELECTEDVALUE(BASE_TOTAL[VERSAO])
    VAR __Date = SELECTEDVALUE(BASE_TOTAL[SAFRA])
    VAR __Year = YEAR(__Date)
    VAR __Table = CALCULATE( SUM(BASE_TOTAL[VALOR]), FILTER( ALL(BASE_TOTAL), [VERSAO] = __Version && YEAR([SAFRA]) = __Year && [SAFRA] <= __Date ) )
RETURN
    __Table