Calculation referencing previous row, utilizing the value within the same calculated column

Hi, pilot_butte ;

You could create a column by dax.

Column = 
VAR _OUT= CALCULATE(MIN('Table'[School Year]),
                    FILTER(ALL('Table'),[StaffUniqueId]=EARLIER('Table'[StaffUniqueId])
                    &&[Hired From]="Outside Hire"
                    &&[Hire Year]>=EARLIER('Table'[Hire Year])))
RETURN IF([School Year]>=_OUT&&_OUT<>BLANK(),_OUT-1,CALCULATE(MIN('Table'[Hire Year]),ALLEXCEPT('Table','Table'[StaffUniqueId])))

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.