Compare data from different dates in the same table

Hi everyone,   I have a data base that updates everyday with new information and I would like to bring the data from the previous day to a new calculated column to be compare with the data from tod...