How do i extract date from the source name which has string using power query

Hi ahamedafridi18,

There are so many different ways to achieve that, just wondering how representative the image is...
For example any of these will do, just insert a Custom Column and copy an expression from below, replace "Source" with the column reference [Source.Name]

let
    Source = "Detroit 21-02-2024.xlsx",
    AlwaysBetween = Text.BetweenDelimiters(Source, " ", "."),
    AtTheEnd = List.Reverse( Text.SplitAny( Source, " .") ){1}?,
    Anywhere = List.First( List.Select( Text.SplitAny( Source, " ."), each Text.Length( Text.Select(_, {"-"}) )=2 ))
in
    Anywhere

 I hope this is helpful

Hi ahamedafridi18,

Here is a Dax query for a calculated column 'Date' to extract the date from the SourceName column and convert into date format

An alternative way in PQ is to use this in a custom column

Text.BetweenDelimiters([Source.Name]," ",".",{0,1})