Accumulated balance

[Nese_FZ]

Hi

I am trying to create the accumulated balance by the launch date but it is not working.

I tested several formulas but it didn't work

Cold you helpe me please?

that´s I expected for

thanks in advance

[Nese_FZ]

Hi 

I tried all, but didn´t work. I solved it by introducing an index column and referencing it.

Anyway, thanks for your help!

[amitchandak]

@Nese_FZ , Use all of table, In place of Table[Date].

example

Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))
Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(Sales),Sales[Sales Date] <=max(Sales[Sales Date])))
Cumm Sales = CALCULATE(SUM(Table[value]),filter(allselected(Table),Table[Date] <=max(Table[Date])))