Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
93
Views
Topic starter
Hi all,
it would be very nice of you if you could help me with the following question.
How do i add a custom column called "calendar week". A section from the file name of the source file has to be written into this new column for each line. The excerpt refers to the 33rd and 33rd position in the file name. (Because the calendar week is only in the file name)
Could you please tell me how to do it with Excel Power Query.
Thx and regards Lulu
Posted : 11/05/2023 11:21 am
Would be easier to help if you could upload a file with some data that resembles your real data.
Posted : 11/05/2023 11:26 am