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) 201...
Need 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])))
az38's avatar
az38
Community Champion
6 years ago

Anonymous 

try a measure

Measure = CALCULATE(SUM('Table'[Codici]),FILTER(ALL('Table'),'Table'[Year]<=MAX('Table'[Year])))
Anonymous's avatar
Anonymous
Not applicable
2 years ago

I got the desired values with the above solution . Now when i am putting legends the graph is showing same values 
Please if you have any solution on this