New column with value from previous (last) date

Hi guys, can someone please help me with this issue: I would like to have in another column product flag from previous date (not DAY-1, but last previous)    I've found a solution for simil...