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
Assuming you are connected to a CSV file:
You can replace the previous weeks file with the updated file at the same location provided you won't be needing data from that file. Also, please remember to rename the file and the structure of the file should not be changed. Then, a simple refresh should update the underlying data.
The other way to approach this is to change the source of your file each week.
You may also go for a better solution by using Power Automate to deal with these situations.
Please feel free to ask for clarification.
Cheers!
Thank you for your reply. If I were to replace the previous weeks file, wouldn't the data be duplicated i.e. 2 rows of the same data?