I am new to power bi and i need to create weekly reports based off data collected in an excel format. I have taken the "week 1" data and created a basic report with the data. My query for the data included duplicating the table to do some math against and removing rows and renaming columns.
I now have "week 2" data. How can I apply the same query that was used to modify the tables for the week 1 data?