Forum Discussion
Solved
cummulative sum by customer
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?
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 __resultBased on this: Better Running Total - Microsoft Power BI Community
Greg_Deckler
Community Champion
Community Championchkapelis Try:
cumtotal column =
VAR __customer = [customer]
VAR __date = [date]
VAR __table = FILTER(ALL('Table'),[customer] = __customer && [date] <= __date)
VAR __result = SUMX(__table, [amount])
RETURN
__resultBased on this: Better Running Total - Microsoft Power BI Community
ok i will