Extract date from file name and include in a new column

[mousematt]

Hi.

I have a column that lists file names (as an example '32.1Checkfile_20240302-Exceptions.xlsx').

I am trying but keep failing to extract the date from the file name (20240302) and put this into a new column in PBI and format this as a date.

Is anyone able to help with a solution? 

[mousematt · Accepted solution]

Perfect.  Thank you so much for your help. 😀

[DataInsights]

@mousematt,

Create a custom column in Power Query with this expression, where Filename is the column name. The argument ChangeType is the previous step name.

AddDate = Table.AddColumn(
    ChangeType,
    "Date",
    each Date.FromText(Text.Middle([Filename], Text.PositionOf([Filename], "_") + 1, 8))
)