Life to Date calculations

[SagarChauhan1]

Hi,

I have a data in below format and i want to take Life to date data in next to Sales column. Example 2017 row should reflect 100+200+300= 600. Can someone help me on this.

Year	Sales
2015	100
2016	200
2017	300
2018	400
2019	500
2020	600
2021	700
2022	800
2023	900

[v-lili6-msft]

hi

just create a simple measure like below:

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

Result:

by the way, for this problem, you could have a look these blog:

https://www.sqlbi.com/articles/computing-running-totals-in-dax/

https://www.wallstreetmojo.com/power-bi-running-total/

https://www.goodly.co.in/running-total-power-bi/

Regards,

Lin