Calculation of running total with conditions

[Anonymous]

Hi all,
I am in need of experts help here.

I want to build a measure for running total balance.
But I have conditions here.
I want that if the running total is less then 150,000 it will show me 150,000
and I want that if it excceds 800,000 it will stop there and show me only 800,000
And here is the problem.
I Made the Running total calculation but I can't find a way to cause the calculation to "delete" all previous calculations and start it over from 150,000 or 800,000.

Here is a how this should look
It starts here with180,000 but it dosent matter. Lets say it starts with 0

Any help?

[amitchandak]

@Anonymous ,

Cumm Sales =

var _1 = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))

return 

Switch true() ,

_1 <= 150000, 150000,

_1 >= 800000, 800000,

_1

)

[Anonymous]

Hi,

This doesn't work
In my example above in March your solution will give me  -573,543 +30,776 +716,253 = 173,486
And as it above then 150000 and less then 800000 the result will be 173,486

But as you can see the result should be  897,029