Return status from previous day

[guilhermemedin1]

I am trying the get the previous status of ovens on the day before. Example. 

How can I create the "Previous day status" collum?

Oven	Daily status	Day	Previous day status
Oven 1	Operating	01/01/22
Oven 2	Operating	01/01/22
Oven 3	Stop	01/01/22
Oven 1	Stop	01/02/22	Operating
Oven 2	Operating	01/02/22	Operating
Oven 3	Stop	01/02/22	Stop

[amitchandak · Accepted solution]

@guilhermemedin1 , a new column

new column =
var _max = Maxx(filter(Table, Table[Oven] =earlier(Table[Oven]) && [Day] < earlier([Day])-1),[Day])
return
Maxx(filter(Table, Table[Oven] =earlier(Table[Oven]) && [Day] = _max),[status])

[guilhermemedin1]

Thanks a lot!