Forum Discussion
TestTest17891
Advocate I
Advocate IGet 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
TestT...
Use the following :
NumericOnly = VAR Result = VALUE([YourColumnName]) // Attempts to convert to number. RETURN IFERROR(Result, BLANK()) // Returns BLANK if conversion fails
AmiraBedh
Super User
Super UserUse the following :
NumericOnly =
VAR Result = VALUE([YourColumnName]) // Attempts to convert to number.
RETURN
IFERROR(Result, BLANK()) // Returns BLANK if conversion fails