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 ,
Could you please tell me what is your data source? If it is a CSV file, I agree with Anonymous 's way. Please refer to it. I have also found a blog, please refer to it to see if it helps you.
Import all CSV files from a folder with their filenames in Power BI
- It only worked on CSV files
- If your CSV files contained crucial meta data in the filename, you “lost” that data after clicking the combine binaries button.
If I have misunderstood your meaning, please provide your pbix file without privacy information and desired output.
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.
Here are the 2 files. I can easily convert them to csv files. However I am not sure how do I upload them in Power BI and ensure the rows do not get duplicated.31.01.22 ext 10.01.22 extract