Forum Discussion
Rolling 13 weeks average to update and replace with new data
Hi Anonymous ,
Please have a try.
Name the two excels with the same format and put them in the same folder.
Steps in Power Query:- Get data in desktop: enter the folder path.
- Filter the excel files you want based on the creation date or modification date.
- Expand content to get data.
- Get the latest data when refresh.
More details; Automatically update data according to the date in the file name
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Please have a try.
Name the two excels with the same format and put them in the same folder.
Steps in Power Query:
- Get data in desktop: enter the folder path.
- Filter the excel files you want based on the creation date or modification date.
- Expand content to get data.
- Get the latest data when refresh.
More details; Automatically update data according to the date in the file name
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you! I will give it a try tomorrow.