Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sum previous year

Hi,

that's my graph:

 

With the blue line (that's a simply distinct count) i need to sum the previous year to the current year.

 

So, it will become:

 

2014: 819

2015: 2412 + (819)

2016: 1702 + (2412 + 819)

....

 

How can i achieve this?

 

Thanks for help

  • az38's avatar
    az38
    6 years ago

    Anonymous 

    try a measure

    Measure = CALCULATE(SUM('Table'[Codici]),FILTER(ALL('Table'),'Table'[Year]<=MAX('Table'[Year])))

12 Replies