I need to create the calculated column with DAX

[gusfablop]

I need to create the calculated column "CumulativeCOL A", where I accumulate the sum of the values in column A, the previous value and the current value, with the formula I show in column E.
That is:
for the cell D2= A2
for the cell D3= +D2+A3
for the cell D4= +D3+A4
for the cell D5= +D4+A5
for the cell D6= +D5+A6
for the cell D7= +D6+A7
for the cell D8= +D7+A8
for the cell D9= +D8+A9
for the cell D10= +D9+A10
for the cell D11= +D10+A11

In Spanish

Necesito crear la columna calculada "CumulativeCOL A", donde acumule la sumatoria de los valores de la columna A, el valor anteriro y el valor actual, con la formula que muestro en la columna E.

O sea:
para la celda D2= A2
para la celda D3= +D2+A3
para la celda D4= +D3+A4
para la celda D5= +D4+A5
para la celda D6= +D5+A6
para la celda D7= +D6+A7
para la celda D8= +D7+A8
para la celda D9= +D8+A9
para la celda D10= +D9+A10
para la celda D11= +D10+A11

[az38]

Hi @gusfablop 

try a measure

CumulativeCOL A = 
var maxVal = max(Table1[Valor A])

return 
calculate(sum(Table1[Valor A]);
ALLSELECTED(Table1);
Table1[Valor A]<=maxVal)

thx for @Mariusz from another topic today

do not hesitate to give a kudo to useful posts and mark solutions as solution

[gusfablop]

Hi @az38.
As a measure, it works well, but I need it to be a calculated column.
Anyway, thank you very much for your contribution.

[az38 · Accepted solution]

@gusfablop 

column

CumulativeCOL A = CALCULATE(sum(Table1[Valor A]);FILTER(ALL(Table1);Table1[Valor A]<=EARLIER(Table1[Valor A])))

do not hesitate to give a kudo to useful posts and mark solutions as solution

[gusfablop]

Thank you so so so so so so so much