Calc Cumulative running total without using a date dimesion table an defining a special start Num

[rp2022]

Sample Data:

Date Label	Total $
P	($100.00)
Mar-24	($300.00)
Apr-24	$100.00
May-24	$200.00
Jun-24	($150.00)
Jul-24	$800.00
Aug-24	$500.00
Sep-24	($200.00)
Oct-24	($100.00)
Nov-24	$200.00
Dec-24	($1,800.00)

Desired Output:

Date Label	Total $	Running $
P	($100.00)	($100.00)
Mar-24	($300.00)	($300.00)
Apr-24	$100.00	($200.00)	=Prev row + Apr-24 Total $
May-24	$200.00	$0.00	=Prev row + May-24 Total $
Jun-24	($150.00)	($150.00)
Jul-24	$800.00	$650.00
Aug-24	$500.00	$1,150.00
Sep-24	($200.00)	$950.00
Oct-24	($100.00)	$850.00
Nov-24	$200.00	$1,050.00
Dec-24	($1,800.00)	($750.00)

[vicky_ · Accepted solution]

You can try something like the following:

Running $ = SUMX(FILTER(ALL('Table'), 'Table'[0] > 0 && 'Table'[0] <= SELECTEDVALUE('Table'[0])), [Total $])

I added an index column to your table since I needed a numeric column to sort by.