Forum Discussion
Power query
Good afternoon with everyone I need a help in the query editor of power BI, I am making a connection to a sharepoint folder in which you have several excels with versions I just need to stay with the latest versions in this case the last _rev of each type of excel, some suggestion.
attached image
Hi Syndicate_Admin ,
If you want to filter the latest version for per date group, you can try the following steps.
1. Add a custom column to get date values.
= Text.Start(Text.Select([Name], {"0".."9"}),4)2. Filter the rows that contain "_rev" and do not start with "~$" in the Name column.
3. Sort the Name column in descending order.
4. Group based on column DateGroup.
5. Create custom column for adding index to the groups.= Table.AddIndexColumn([All],"Index",1)6. Remove all columns except column Data, then extend column Data.
7. Filter rows with [Index] = 1.
8. You will get:
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Syndicate_Admin ,
If you want to filter the latest version for per date group, you can try the following steps.
1. Add a custom column to get date values.
= Text.Start(Text.Select([Name], {"0".."9"}),4)2. Filter the rows that contain "_rev" and do not start with "~$" in the Name column.
3. Sort the Name column in descending order.
4. Group based on column DateGroup.
5. Create custom column for adding index to the groups.= Table.AddIndexColumn([All],"Index",1)6. Remove all columns except column Data, then extend column Data.
7. Filter rows with [Index] = 1.
8. You will get:
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
WinnizIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
