Calculating cumulative values with drillable dates

Hi AlishaN ,

You may try this solution.

1 Use Year, Month, Week columns from Date Table as shared axis

2 Use the following Measure to calculate cumulative total transactions

Cumulative Total Transactions =
CALCULATE (
    [Total Transactions],
    FILTER (
        ALL ( 'Date Table' ),
        'Date Table'[TRANS_Dates] <= MAX ( 'Date Table'[TRANS_Dates] )
    )
)

Then, the result should look like this.

Also, attached the pbix file as reference.

Best Regards,

Community Support Team _ Caiyun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!