Hey all,
Hoping this might be an easy one for you experts
I currently have a daily sales export set up to return the start of the previous month, up to MTD (So today's file will be 1st September to 5th October) What I'm trying to do is to save myself having to copy and paste the data on top of itself each day, is there a way to get Power Query to just keep adding the new dates data at the bottom of the table each day???
Youll see from the below, each day im having to find the 1st of the previous month and paste the data over the top. Trying to be more effective and cut out the middle man if i just export and save the file down in a sharepoint / onedrive folder then use the 'Get Data' option
Hoping this might be an easy one for you experts
I currently have a daily sales export set up to return the start of the previous month, up to MTD (So today's file will be 1st September to 5th October) What I'm trying to do is to save myself having to copy and paste the data on top of itself each day, is there a way to get Power Query to just keep adding the new dates data at the bottom of the table each day???
Youll see from the below, each day im having to find the 1st of the previous month and paste the data over the top. Trying to be more effective and cut out the middle man if i just export and save the file down in a sharepoint / onedrive folder then use the 'Get Data' option