Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
ahamedafridi18
Frequent Visitor

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

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.image.png

3 REPLIES 3
Vijay_A_Verma
Super User
Super User

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

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

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

 

Date = FORMAT(DATEVALUE(RIGHT(LEFT([Source.Name],18),10)),"DD-MM-YYYY")
 
If you like my solution please consider giving a upvote..
 
Thank you!
 
 
m_dekorte
Super User
Super User

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors