Calculating cummulative total by date and by id

[RahulKumarBIT]

Hi

I am looking to calculate cummulative total by date and by id. My existing table and its three column's are per below

Date	ID	Amount
01/31/2023	501	5
02/28/2023	501	10
01/31/2023	502	3
02/28/2023	502	6

Expected Table with 4rth calculated column-CummulativeAmount

Date	ID	Amount	CummulativeAmount
01/31/2023	501	5	5
02/28/2023	501	10	15
01/31/2023	502	3	3
02/28/2023	502	6	9

[some_bih]

Hi @RahulKumarBIT , create two measures:

Sales Amount = SUM(Sheet2[Amount]) and

Cummulative Amount =

    CALCULATE(

        [Sales Amount],

        DATESYTD(Sheet2[Date])

    )

 Columns and ID are from table Sheet2, so you need to adjust to your table name. Please note that visual is created as you shown. I hope this help.

[RahulKumarBIT]

Hi @some_bih

Will DATESYTD work with whole date series before and after 2023 as well as i would need cummulative total as of any dates?