PowerQuery - change cells names each week

hi,

I am receiving sales volumes table each week. What I have to do, is to compare volumes from the current table vs last week table. Both tables' names are usually with a week number, but it does not matter here. I am able to check which is the latest based on modification date, but I cannot hard-code its names in PowerQuery, because I would have to update it every week.

Is there any way to change the names of both files (or SourceNames) to: CurrentWeek and LastWeek?

pls see the file attached - based table and final table

Hi,

I loaded your source into PQ. Then I added the ISO Weeknumber for the current date, split the source name by delimiter W, subtract the current week from the source week and can then determine the current and the last week.


Rest is easy.