Help with counting when comparing to previous columns

Hello,
I'm hoping this is simple, but I can't seem to figure it out.

I have a sheet of data that has the number on hand of items based on dates:

I'm trying to make a Matrix in Desktop that compares the Count Sum of one date to the previous and tells me if it switched from Positive to Negative or Negative to Positive:

I have the Total Positive and Total Negative working for each date but I am having trouble figuring out a formula the will evaluate each item to see if it went from positive to negative and then negative to positive.
This is as close as I have gotten:

Value =

VAR MAXD = CALCULATE( MAX ('Table1'[Date]) )

VAR PREVD = CALCULATE( MAX('Table1'[Date]), 'Table1'[Date] < MAXD )

RETURN

SWITCH(

    TRUE(),

    SELECTEDVALUE('Maxtrix'[Header#]) = Total Positive,

    CALCULATE(COUNTROWS('Table1'), 'Table1'[Count Sum]>0), **This Works**

    SELECTEDVALUE('Maxtrix'[Header#]) = Total Negative,

    CALCULATE(COUNTROWS('Table1'), 'Table1'[Count Sum]<0), **This Works**

    SELECTEDVALUE('Maxtrix'[Header#]) = Positive to Negative,

    CALCULATE(COUNTROWS('Table1'), 'Table1'[Date]=MAXD && 'Table1'[Count Sum]>0, 'Table1'[Date]=PREVD && 'Table1'[Count Sum]<0 ),

 

    SELECTEDVALUE('Maxtrix'[Header#]) = Negative to Positive,

    CALCULATE(COUNTROWS('Table1'), 'Table1'[Date]=MAXD && 'Table1'[Count Sum]<0, 'Table1'[Date]=PREVD && 'Table1'[Count Sum]>0 ),

)

 

Thank you in advance for the help!