Forum Discussion

B_Albuquerque's avatar
B_Albuquerque
Frequent Visitor
9 years ago
Solved

Need Help: Filter of Non-Numeric Values

I need to create a new column that don't have the non-numeric values of the original one. Can someone help?
  • B_Albuquerque's avatar
    B_Albuquerque
    9 years ago

    Its says that I can't convert from Text to Number.

  • Anonymous's avatar
    Anonymous
    9 years ago

    Can you use a calculated column with DAX like:

     

    Column = IFERROR(VALUE([Column1]), BLANK())

     

    The VALUE function will try to convert the parameter to a number. IFERROR will return blank