Forum Discussion
Solved
Get only numeric values from a column
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
Use the following :
NumericOnly = VAR Result = VALUE([YourColumnName]) // Attempts to convert to number. RETURN IFERROR(Result, BLANK()) // Returns BLANK if conversion fails
1 Reply
Use the following :
NumericOnly = VAR Result = VALUE([YourColumnName]) // Attempts to convert to number. RETURN IFERROR(Result, BLANK()) // Returns BLANK if conversion fails