Forum Discussion
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 ...
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!