Get only numeric values from a column

[TestTest17891]

I want to create a calculated column in DAX that filters out only the numeric values from a column that contains numbers, strings, and dates....

Example :

MyColumn       CalculatedColumn

TestTest        --ignore

123              123

01/01/1966      --ignore

569              569

[AmiraBedh · Accepted solution]

Use the following :

NumericOnly = 
VAR Result = VALUE([YourColumnName]) // Attempts to convert to number.
RETURN
IFERROR(Result, BLANK()) // Returns BLANK if conversion fails