Cumulative bar chart

[Thom_vee]

I`m just getting started with Power BI. I have a table called observations , in which I have a column called "created_on" (dd:mm:yyy:hh:mm:ss). I have charted out a bar graph of no of observations per year using this column. However, I wish to make a colum showing the cumulative growth over the years so that I can generate a chart of the cumulative upload of obsetrvations across all years (1970 - 2017).

eg:
created_on
09-03-2017: 16:26:00
01-06-2016: 16:26:00
03-04-2016: 16:26:00
06-03-2015: 16:26:00
04-11-2016: 16:26:00
02-08-2016: 16:26:00
31-12-2015: 16:26:00
27-04-2014: 16:26:00

so the count every year:
2014 - 1
2015 - 2
2016 - 4
2017 - 1

What I want is cumulative addition of the previous years:
2014 - 1
2015 - 3
2016 - 7
2017 - 8

Can anyone please help?

 

[gazpage]

You can use quick measures for this sort of thing. Go to options and settings preview features and enable quick measures.

Gave me:

Data running total in Year = 
CALCULATE(
 SUM('Inputs'[Data]),
 FILTER(
  ALLSELECTED('Inputs'[Year]),
  ISONORAFTER('Inputs'[Year], MAX('Inputs'[Year]), DESC)
 )
)

 

[Thom_vee]

You can use quick measures for this sort of thing. Go to options and settings preview features and enable quick measures.

Gave me:

Data running total in Year = 
CALCULATE(
 SUM('Inputs'[Data]),
 FILTER(
  ALLSELECTED('Inputs'[Year]),
  ISONORAFTER('Inputs'[Year], MAX('Inputs'[Year]), DESC)
 )
)

Thank you I tried that but it gives me the same value over every year!