Forum Discussion

voidbydefault's avatar
voidbydefault
Helper I
3 years ago

Problem with cumulative(running) total

Hi, I am trying to calculate a cumulative/running total using:   Running Invoiced Amounts = VAR CurrentDate = MAX(AR_Balances[GL Date]) RETURN CALCULATE( SUMX(AR_Balances, AR_Balances[Invoi...
voidbydefault's avatar
voidbydefault
Helper I
3 years ago

Update:
I have managed to fix the first issue where cumulative total started with the sum of all invoices (i.e. 1,050) using below DAX. Please help me with the second problem. Thanks:

 

Solution to # 1:

Running Invoiced Amounts = 
VAR CurrentDate = MAX(AR_Balances[GL Date])
RETURN

CALCULATE(
    SUMX(AR_Balances, AR_Balances[Invoice Amount]),
    AR_Balances[GL Date] <= CurrentDate
)