Calculate Sum of weekly value only if previous week was negative

[Anonymous]

I am trying to do a running sum af resource availability.  But if a resource is over-used the previous week, I would like to subtract it from the current week.  If it is under-used I do not want it to carry forward.  For instance:

Capacity	14	14	14	14	14
Orders	12	16	13	12	10
Available	2	-2	-1	1	4

[amitchandak]

@Anonymous , do you same week or Date to do that.

You can refer these WOW blog/video, if they can help

https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8

[AllisonKennedy]

@Anonymous  What does your raw data look like please? 

You can do IF([Available]<0, [Available]+[Current], [Current])

type of logic, but we need to know what your raw data looks like to be able to detail exactly how. 

[Anonymous]

My data includes:

Column: Truck Capacity

MEASURE: Open Orders = (SUM('Table1'[Converted Volume])/31) +0

MEASURE: Available Calculation = CALCULATE(SUM(Table2[Truck Capacity])-[Open Orders])

I am currently using this measure for the running calculation: 

Available Running Total = IF(

CALCULATE([Available Calculation]<0, DATEDIFF(Table2[Shipment Date], TODAY(), WEEK) = 1),

CALCULATE(

    [Available Calculation],

    FILTER(

        ALLSELECTED('Table2'[Shipment Date]),

        ISONORAFTER('Table2'[Shipment Date], MAX('Table2'[Shipment Date]), DESC)

    )

),[Available Calculation])

But the problem is, if this week is positive and last week was negative, it does not carry the negative value forward.  So I need to look if the previous Available Running Total is negative, then I need to carry it forward.  But I feel like that creates a circular equation.