calculate amount of the quarter when you have the cumulative amount

[nasolme]

Hi community, 

I have the database with cumulative amount and i want to calculate the non-accumulated amount.

Do you have any idea ?

Thx in advance

[nasolme]

Thank you again @amitchandak 

[amitchandak · Accepted solution]

@nasolme , Create a new column

=

var _year = Year([Date])
var _last = maxx(filter(Table, [Date] < earlier([Date]) && Year([Date]) =_year), [Date])
return
[cumulative amount] - maxx(filter(Table, [Date] =_last ), [cumulative amount])