Skybluekid
Well-known Member
- Joined
- Apr 17, 2012
- Messages
- 1,231
- Office Version
- 365
- Platform
- Windows
Hi everyone,
I have a sharepoint folder, which holds Excel files produced week, so they are named Week 1, Week 2, and so on. I would like to upload using the get Files from Folder option. The problem is the data on the sheets. On the sheets there is no Dates so I am not able to label up which week is which. Is there a way in Powery query to insert a column to show the week which the data relates to.
Thanks in advance.
I have a sharepoint folder, which holds Excel files produced week, so they are named Week 1, Week 2, and so on. I would like to upload using the get Files from Folder option. The problem is the data on the sheets. On the sheets there is no Dates so I am not able to label up which week is which. Is there a way in Powery query to insert a column to show the week which the data relates to.
Thanks in advance.