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
2 Replies
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
ok i will
