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?
