Search in script in previous loaded data according more conditions.

[Juraj_SK]

Dear experts,

I would like to ask you for support.

By loading data I would like to add column “Previous_Price” according 2 conditions (needs to match Product and time frame of Date).

“Previous_Price” shoud be: Find previous price for Product which is first in time-frame starting 365 days backward.

Expected result is distinguishable by colors.

Obstacle for me is to combine 2 conditions by searching the value in previous loaded data.

Thank you very much in advance.

Juraj