Create a new price column with the earlier date for a same product name

[Luiz]

Hi,

I mean, I would like to insert a "Earlier date Price" column for the same product, in this table

Thanks.

[Ashish_Mathur]

Hi,

Try this calculated column formula

=lookupvalue(data[Price],data[date],calculate(max(Data[Date]),filter(Data,Data[Date]<earlier(Data[Date])&&Data[Product]=earlier(Data[Product]))),data[product],data[product])

Hope this helps.

[amitchandak · Accepted solution]

@Luiz , Try a new column like

new column =
var _date = maxx(filter(Table, [product] =earlier([product]) && [Date] <earlier([Date])),[Date])
return
var _date = maxx(filter(Table, [product] =earlier([product]) && [Date] =_date ),[price])

or the set of these two columns

last Date =
maxx(filter(Table, [product] =earlier([product]) && [Date] <earlier([Date])),[Date])

last Price =
maxx(filter(Table, [product] =earlier([product]) && [Date] =earlier([last Date])),[price])

[Luiz]

It works! Thanks a lot!