Forum Discussion
Need help in data
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
4 Replies
Please Help
still not clear about this. could you pls provide more detailed data? So far your data file can't get the output.
how to get the output?
I only see 5000 for apple. where can we get 4599, 4499 and 4399?
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.
