Cumulative total Year on Year

Please help! I would like a measure that gets me the cumulative total year on year. Thank you

Need Help

v-yalanwu-msft

4 years ago

Hi, ronaldt5 ;

Base on my understand , you could create a measure .

Measure = 
CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),[name]=MAX('Table'[name])&&[Date]<=MAX('Table'[Date])))

percent% = 
var _result=
DIVIDE(SUM('Table'[value]),
CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),[name]=MAX('Table'[name])&& YEAR([Date])=YEAR(MAX('Table'[Date]))-1)))-1
return IF(_result<>-1,_result)

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Cumulative total Year on Year.pbix392 KB

percent% = var _result= DIVIDE(SUM('Table'[value]), CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),[name]=MAX('Table'[name])&& YEAR([Date])=YEAR(MAX('Table'[Date]))-1)))-1 return IF(_result<>-1,_result)

Forum Discussion

Cumulative total Year on Year