multi sum with cumulative value

[clmigeon]

Hi ,

Thank for your help you provid me on a other matter. 

I realise that my problem is more complicat . 
in fact i have : 

Noaccount	Nojourn	Credit	devit	date	sc
51120	40	50000	0	01/01/2020	TOTO
51120	16	500	0	01/01/2020	TOTO
51120	16	0	-200	01/02/2020	TOTO
51120	16	400	0	01/02/2020	TOTO
45200	16	500	0	01/04/2020	TOTO
45200	16	0	-200	01/02/2020	TOTO
45200	16	400	0	01/01/2020	TOTO
45200	16	0	-500	01/02/2020	TOTO
45200	16	400	0	01/01/2020	TATA
45200	16	0	-500	01/02/2020	TATA
51120	40	50000	0	01/01/2020	TATA
51120	16	500	0	01/01/2020	TATA

And I want that a repport like 

SC	Noaccount	01/01/2020	01/02/2020	01/03/2020
TATA	51120	50500
45200	400	-100
TOTO	51120	50500	50900
45200	400	-300	200

[clmigeon]

Thx @MFelix  ! it work 🙂

could a ask a last advice ? 
I have for each information an other value Nojourn , i need to take the Value 1 time for one id (40) , i need to take the older value. 
For Exemple : 

In 03/10/2020 i need to skip the value in the sum , how could i ? 

[clmigeon]

hi @MFelix , 
Thank for the help, i don't understand why it doesn't work on me : 

Measure = CALCULATE(SUM('Feuil1'[Credit]) + SUM('Feuil1'[devit]), FILTER(ALL('Feuil1'[1/1/2020]) , 'Feuil1'[1/1/2020] <= MAX('Feuil1'[1/1/2020])))

[MFelix]

Hi @clmigeon ,

This is not a calculated column you need to create a measure. Right click on the table but instead of adding a new column add a new measure.

Also taking into attention you have a column with transaction that basically is the credit/debit you can redo your measure to:

Measure = CALCULATE(SUM('Feuil1'[Transaction]), FILTER(ALL('Feuil1'[1/1/2020]) , 'Feuil1'[1/1/2020] <= MAX('Feuil1'[1/1/2020])))

[MFelix · Accepted solution]

Hi @clmigeon ,

To what I can see you want the calculation to be cumulative in this case try the following measure:

Measure = CALCULATE(SUM('Table'[Credit]) + SUM('Table'[devit]), FILTER(ALL('Table'[date]) , 'Table'[date] <= MAX('Table'[date])))

then use a matrix visualization: