Accumulated balance

[nadav50]

hi,

can i get help?

i want to add accumulated column  per client like the  next pic :

[v-yulgu-msft · Accepted solution]

Hi @nadav50,

Please add a calculated column using below formula:

balance_by_client =
CALCULATE (
    SUM ( 'Accumulated balance'[sale] ),
    ALLEXCEPT ( 'Accumulated balance', 'Accumulated balance'[Client] ),
    'Accumulated balance'[date] <= EARLIER ( 'Accumulated balance'[date] )
)

If you have any other question, please feel free to ask.

Thanks,
Yuliana Gu

[Anonymous]

Hi,

I was wondering if it is possible to calculate the last column in yellow in power bi?

I am after the resul which is found in the final column (cumulation), as an accumulation calculation.Total number is 832.

Ant fadder donasjoner (Kontakt)	Count of Kundenummer (Kontakt)	Cumulation
0	389	443
1	120	323
2	85	238
3	74	164
4	30	134
5	31	103
6	35	68
7	26	42
8	16	26
9	13	13
10	10	3
11	1	2
30	1	1
36	1	0
Total	832

Thank you for your helo 🙂