Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
i have exported csv dat which has got date in their source name. it is a daily download report. i want to create a custom column which extracts the date from the source name so that i can cretae the date column for the dataset.
An alternative way in PQ is to use this in a custom column
Text.BetweenDelimiters([Source.Name]," ",".",{0,1})
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
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