Create date column based on file name?

[Paranthem]

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.