file replace automatically

[yanzhao_LBS]

i get date from sharepoint folder and there will be 2 file for the 1 Powerbi Table. and the 2 file is version 1 and version 2. Now the default is the version 1 and version 2 file will be "append "

 for example:

the version 1 data:

filename	Date	Vendor	product	QTY
Version20231005	2023-10-05	A	iphone 14	10
Version20231005	2023-10-05	A	iphone 15	20
Version20231005	2023-10-05	B	iphone 15	2
Version20231005	2023-10-05	C	iphone 12	4
Version20231005	2023-10-05	C	iphone 13	3
Version20231005	2023-10-05	D	iphone 14	6
Version20231005	2023-10-05	D	iphone 15	9

the version 2 data :

filename	Date	Vendor	product	QTY
Version20231025	2023-10-25	A	iphone 14	3
Version20231025	2023-10-25	A	iphone 15	3
Version20231025	2023-10-25	C	iphone 12	3
Version20231025	2023-10-25	C	iphone 13	3
Version20231025	2023-10-25	D	iphone 14	3
Version20231025	2023-10-25	D	iphone 15	3

what i want is when there is only version 1 file existing ,the table just get the version 1 data

when there are version 1 version 2 existing, just keep the version 2 ( means keep the latest date file) , which means for the above 2 version file ,i only need the version 2 data,as it has the later date. 

is there any way to achieve this?

[lbendlin · Accepted solution]

When you connect to the sharepoint folder, you sort the file list by an appropriate criteria (for example file name descending) and then you grab the binary of the first row, like #"Sorted Rows"[Contents]{0}

[yanzhao_LBS]

sounds a practicable approach ,i will try that and accept this as a solution when it works.