Sum up previous data

[Anonymous]

Hi all

So i want to create a line chart, axis are dates, value is the achievement process of sales goal.

Lets say on dez 31 2019 the achievement was 100%, but when inserted in a line chart it shows the daily achivement, so everyday has about the same line height.

What i want instead is summing up the values from previous dates, so dez 31 has the whole 100% and you can see the trend.

Thanks and regards

[FrankAT · Accepted solution]

Hi @Anonymous 

see figure:

Regards Frank AT

[amitchandak]

Try like

last Day= CALCULATE(SUM(Sales[Sales Amount]),(dateadd('Date'[Date],-1,DAY)))

[Anonymous]

Thanks for the quick response @amitchandak 

Didnt work for me, gives me the same result as just adding the measure by itself.

I think i forgot to mention the achivement goal is a measure, so i cant sum it..