Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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}
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}
sounds a practicable approach ,i will try that and accept this as a solution when it works.
User | Count |
---|---|
89 | |
88 | |
75 | |
67 | |
58 |
User | Count |
---|---|
137 | |
110 | |
93 | |
84 | |
69 |