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