New column with data from another column - 1 day

[Anonymous]

Hi

I have a table like this:

As you can see first column is date column and second is just data, I need to make a third column that it would show previous day data from second column.

In example the last 3 rows in that table should look like this:

[amitchandak · Accepted solution]

@Anonymous , Create a new column like

new column =
var _max = maxx(filter(table, [Date] < earlier([Date])),[Date])
return
maxx(filter(table, [Date] = _max),[Data]) //Data is the second column