Question on Calculations

So to clarify, what I am doing is analyzing total sales and total transaction counts.  The table has a field for total sales and a field for total transaction count by the State the sale was made.  It also has a stagnant field for the total sales threshold and total sales count of transaction by State.  What I am wanting to do is have a calculated field or something that shows when either of the thresholds are passed.  This field would be called Date Threshold Met.

Example:  For Alaska the threshold is 100,000 in total sales and 200 in total count of transactions.  Actual sales for August is 95,000 and total transaction count is 175.  In September, the sales goes to 103,458 which passes the threshold of 100,000.  At that point the field called Date Threshold met would be 09/01/2020.  The first of the month the threshold was met or passed. 

Second, this date would then never change as once a threshold is passed, it is passed.  If it has not passed either of the thresholds, the field is NULL.