Running Sum variant

[CahabaData]

say there is a Values column

5

5

5

-2

-1

5

the Running Sum measure would be:

5

10

15

13

12

17

if one needed a maximum of 12 and applied a simple IF/Switch result would be

5

10

12

12

12

12

but for the running sum to be based on the prior value of its own field/column - intellisense will not allow that measure to get written because of circular reference.  The result sought is:

 5    5

 5    10

 5    12

-2   10

-1    9

 5   12

perhaps there is another function that will work - or approach

would welcome advice on this one - has me stumped...... I should add one can assume that adding an Index column is possible.

@conniedevina