Update most recently updated records, in newer files & drop them from older files in sharepoint

[japjeets]

I am connecting to a sharepoint folder where i get CSV files sent to me every day for last 1 month.
for example, I have 3 files
File 0, received on 4th August has data from Dates Between 07/4/2025 - 8/7/2025
File 1, received on 5th August has Data from Dates Between 7/5/2025 - 8/8/2025
File 2, received on 6th August has data from Dates between 7/6/2025 - 8/9/2025

I want to pull data into power bi, in such a way that
On 4th August, I import all data,
On 5th August I Keep the Data for 7/4/2025 from File 0, drop rest of the data and pull all data from File1,
on 6th August I keep the Data for 7/5/2025 from File 1,  drop rest of the data and pull All Data From File2  and so on for every incremental date. 

I am unable to articulate the best strategy to implement this using power query

Columns i have in CSV File are as follows : 

Nominal Dates : eg -07/06/2025 to 08/09/2025
Employee Name:
Attendance Code: eg PTO, Leae, Late In etc.. 
Nominal Date:
Start Time:
End Time:

Duration:
Memo: 

[collinsg]

Good day jaeets,

If the data for a date does not change after being recorded, then you could get all the files from the folder and use "Remove Duplicates" on the date column. This would leave one row for each date, achieving your goal.

Hope this helps

[v-dineshya · Accepted solution]

Hi @japjeets ,

Thank you for reaching out to the Microsoft Community Forum.

Hi @SundarRaj , Thank you for your prompt response.

Hi @japjeets , As suggested by @SundarRaj  to you . Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). Do not include sensitive information. Do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided.

Regards,
Dinesh

[v-dineshya]

Hi @japjeets ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[v-dineshya]

Hi @japjeets ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[v-dineshya]

Hi @japjeets ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

[SundarRaj]

Hi @japjeets ,

Can you send your sample data to work with?