Making the Difference between a sum of values

[MartinMendina]

I have Data like this

Date                                  Amount 1                       Account

2002-08-31                     5                                           1

2022-07-31                     3                                           1

2022-06-30                    3                                            1

2002-08-31                     1                                           2

2022-07-31                     2                                           2

2022-06-30                   1                                            2

If i sum everything by date I have

Date

2022-08-31 Sum(Amount1)=6

2022-07-31 Sum(Amount1)=5

2022-07-31 Sum(Amount1)=4

But then I need to create a line graph with Date as a measure and with height of the bar with

2022-08-31 Sum(Amount1, In date t)-Sum(Amount1,In date t-1)

The desired output of the example woul be a line graph with

2022-08-31 1 

2022-07-31 1

Thanks

[rubenmarin · Accepted solution]

Hi, if you expand the measure there is an option to set a modifier, selecting 'Difference' will do the trick.