Need help in data

[AnkurSharma]

Hi everyone,

I have one Data file which is refreshed by(IT) SQL query  every day. Data contains price of Product and its product name. Every day data file shows latest price.

I want to create one report which shows me what was price yesterday or day before yesterday.

Please sugest. I am ok for both Options Power query or power Bi. I know its easy in excel using Vlookup but i want to do in Power query or power bi.

Data File:

Product	Latest Price
Apple	5000
Samsung	8000
LG	8500

Output:

Procuct	Latest Price	21 Nov Price	20 Nov Price	19 Nov Price
Apple	5000	4599	4499	4399
Samsung	8000	7599	6599	8999
LG	8500	7500	6500	5500

Thanks in advance

[ryan_mayu]

how to get the output?

I only see 5000 for apple. where can we get 4599, 4499 and 4399?

[AnkurSharma]

Those no's are next day no and i want to update next day no and previous day as well.

Every Day IT department updates price of all products , i want to track all price change in one sheet.

[AnkurSharma]

Please Help

[ryan_mayu]

still not clear about this. could you pls provide more detailed data? So far your data file can't get the output.