How to get a running total in a line chart?

[dankello]

Hi,

I have the following table and i'm looking to create a line chart in Power BI as per the example below (please excuse the drawing). How do I get a running total of 'Items' on each date? i.e. for 'Admin', on the 4/6/2024, the total on the line chart would be 40.

Example of running total:

Thank you,

Daniel

[dankello]

Thank you so much @MFelix! Yes this worked 🙂

[MFelix · Accepted solution]

Hi @dankello ,

Try to create the following measure:

Total Values = CALCULATE( SUM(Table[Items]), Table[Date] <= MAX(Table[Date]))