how to separate dates from a column which also text in it

[Anonymous]

I am having an issue with the DAX formula for separating the dates and removing the text. I have a column A which has dates as well as text. I need to keep only dates and remove the text. If I use this formula = Table.AddColumn(Source, "Date", each if [RequestCompletionDate] = "1/22/2020" then [RequestCompletionDate] else "") then it works for the specific date but not sure what to do extract all dates. Below is a sample example of my data.

A

Complete

HUB234

01/22/2020

xyzxkaed

05/08/2021

Any help is appreciated.

[Anonymous]

I got my answer. This is what I used to extract my dates from a column

Using Power Query to Extract Dates from Text String - YouTube

[daxer-almighty]

First, this is not DAX but M, the language of Power Query. Second, you can use a function that casts a string into a date and then filter out the rows where this casting returns an error. Look for a function like Date.FromText... or something similar.