John Davies
New Member
Members
Forum Posts: 2
Member Since:
October 27, 2021
October 27, 2021
Offline
Hello,
Does anyone know the method to create a new column in Power Query based off of a source file name?
For example, my source file is named 10.24.2021.xlsx. I want Power Query to generate a new column typed as a date that understands all records associated with that file to have 10/24/2021 as their value.
Thank you.
Mynda Treacy
Admin
Forum Posts: 4693
Member Since:
July 16, 2010
July 16, 2010
Offline
Hi John,
Welcome to our forum!
Presumably the source file name is in a column. If so, you can simply use Replace to remove the .xlsx and then format the column as Date data type. If Date data type returns an error, then you can use Replace again to replace the . with /.
Mynda
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: rocketfinger, Riny van Eekelen, Deon Bouwer
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1909
SunnyKow: 1432
Anders Sehlstedt: 899
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 279
lea cohen: 245
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Francine Walshe
Sean Ladlow
Jorge Chicas
mahmoud salem
Irvine Choolo
Deon Bouwer
Amgad Squires
jim bo
Linda Bock
Hildebrando Rodrigues
Forum Stats:
Groups: 3
Forums: 24
Topics: 6834
Posts: 29979
Member Stats:
Guest Posters: 49
Members: 33567
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —