cummulative sum by customer

[chkapelis]

Hello Everybody,

I have this table 

i want to create the yellow column that calculates a cummulative sum for payments per customer. Is this possible?

[Greg_Deckler · Accepted solution]

@chkapelis Try: 

cumtotal column = 
  VAR __customer = [customer]
  VAR __date = [date]
  VAR __table = FILTER(ALL('Table'),[customer] = __customer && [date] <= __date)
  VAR __result = SUMX(__table, [amount])
RETURN
  __result

Based on this: Better Running Total - Microsoft Power BI Community

[chkapelis]

ok i will