How to compare rows and create a new measure or calculated column?

Hi All,   Hope you are doing well!   I am having some data and want to create a new column by comparing the rows. If the order number and season is the same , the one with the earliest  ISW is gr...