Forum Discussion
Retrieve data from multiple files present in file path with the logic of loading data
Hi,
I need to Prices data should be added to added to an existing report which is based on Weekly/Monthly selection.
Source team is generating prices file on daily basis for all working days which has all forward prices data like below.
Sample data for files generation on daily basis.
Sample data available in the files:
As per above example all the forward prices will be available in the daily file. For eg: File i.e generated on 10-Apr-2023 is having prices from 10-Apr-2023 to till this year end. File i.e generated on 11-Apr-2023 is having prices from 11-Apr-2023.
Below is my requimrement
1. if I select Week14(9-Apr-2023 to 15-Apr-2023) pries for that week to be to be pulled from the previous week last working day file i.e 6-Apr-2023.(Note: Weeks starts from Sunday always)
2. if I select Apr-2023, pries for that month to be to be pulled from last working day of last month i.e 31-Mar-2023.
As like above based on weekly or monthly selection data to be automatically pulled from last working day of weekly or monthly file.
Kindly assist me on this.
3 Replies
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Below is sample data for Retrieve data from multiple files present in file path with the logic of loading current week prices from last week last working day file generation.
FileName Date Price Price_03-03-2023 3-Mar-23 710 Price_03-03-2023 4-Mar-23 720 Price_03-03-2023 5-Mar-23 730 Price_03-03-2023 6-Mar-23 740 Price_03-03-2023 7-Mar-23 750 Price_03-03-2023 8-Mar-23 760 Price_03-03-2023 9-Mar-23 770 Price_03-03-2023 10-Mar-23 780 Price_03-03-2023 11-Mar-23 790 Price_03-03-2023 12-Mar-23 800 Price_03-03-2023 13-Mar-23 810 Price_03-03-2023 14-Mar-23 820 Price_03-03-2023 15-Mar-23 830 Price_03-03-2023 16-Mar-23 840 Price_03-03-2023 17-Mar-23 850 Price_03-03-2023 18-Mar-23 860 Price_03-03-2023 19-Mar-23 870 Price_03-03-2023 20-Mar-23 880 Price_03-03-2023 21-Mar-23 890 Price_03-03-2023 22-Mar-23 900 Price_03-03-2023 23-Mar-23 910 Price_03-03-2023 24-Mar-23 920 Price_03-03-2023 25-Mar-23 930 Price_03-03-2023 26-Mar-23 940 Price_03-03-2023 27-Mar-23 950 Price_03-03-2023 28-Mar-23 960 Price_03-03-2023 29-Mar-23 970 Price_03-03-2023 30-Mar-23 980 Price_03-03-2023 31-Mar-23 990 Price_04-03-2023 4-Mar-23 1000 Price_04-03-2023 5-Mar-23 1010 Price_04-03-2023 6-Mar-23 1020 Price_04-03-2023 7-Mar-23 1030 Price_04-03-2023 8-Mar-23 1040 Price_04-03-2023 9-Mar-23 1050 Price_04-03-2023 10-Mar-23 1060 Price_04-03-2023 11-Mar-23 1070 Price_04-03-2023 12-Mar-23 1080 Price_04-03-2023 13-Mar-23 1090 Price_04-03-2023 14-Mar-23 1100 Price_04-03-2023 15-Mar-23 1110 Price_04-03-2023 16-Mar-23 1120 Price_04-03-2023 17-Mar-23 1130 Price_04-03-2023 18-Mar-23 1140 Price_04-03-2023 19-Mar-23 1150 Price_04-03-2023 20-Mar-23 1160 Price_04-03-2023 21-Mar-23 1170 Price_04-03-2023 22-Mar-23 1180 Price_04-03-2023 23-Mar-23 1190 Price_04-03-2023 24-Mar-23 1200 Price_04-03-2023 25-Mar-23 1210 Price_04-03-2023 26-Mar-23 1220 Price_04-03-2023 27-Mar-23 1230 Price_04-03-2023 28-Mar-23 1240 Price_04-03-2023 29-Mar-23 1250 Price_04-03-2023 30-Mar-23 1260 Price_04-03-2023 31-Mar-23 1270 Price_05-03-2023 5-Mar-23 1280 Price_05-03-2023 6-Mar-23 1290 Price_05-03-2023 7-Mar-23 1300 Price_05-03-2023 8-Mar-23 1310 Price_05-03-2023 9-Mar-23 1320 Price_05-03-2023 10-Mar-23 1330 Price_05-03-2023 11-Mar-23 1340 Price_05-03-2023 12-Mar-23 1350 Price_05-03-2023 13-Mar-23 1360 Price_05-03-2023 14-Mar-23 1370 Price_05-03-2023 15-Mar-23 1380 Price_05-03-2023 16-Mar-23 1390 Price_05-03-2023 17-Mar-23 1400 Price_05-03-2023 18-Mar-23 1410 Price_05-03-2023 19-Mar-23 1420 Price_05-03-2023 20-Mar-23 1430 Price_05-03-2023 21-Mar-23 1440 Price_05-03-2023 22-Mar-23 1450 Price_05-03-2023 23-Mar-23 1460 Price_05-03-2023 24-Mar-23 1470 Price_05-03-2023 25-Mar-23 1480 Price_05-03-2023 26-Mar-23 1490 Price_05-03-2023 27-Mar-23 1500 Price_05-03-2023 28-Mar-23 1510 Price_05-03-2023 29-Mar-23 1520 Price_05-03-2023 30-Mar-23 1530 Price_05-03-2023 31-Mar-23 1540 Note: 1. Each file has forward prices till year end. I have given example till month end.
2. Week always starts from Sunday & Ends with Monday
Output for Week9:
Output for Week9 should be: 5-Mar-23 730 6-Mar-23 740 7-Mar-23 750 8-Mar-23 760 9-Mar-23 770 10-Mar-23 780 11-Mar-23 790 In the above examle I have selected Week9(5-Mar-2023 to 11-Mar-2023). Prices for Week9 did fetch from Previous week(Week8) Last working day file(3-Mar-2023).
- lbendlin
Please define "working day" - is that Monday through Friday?
Your sample data only applies to the weekly scenario, right?
