Need Help: Filter of Non-Numeric Values

[B_Albuquerque]

I need to create a new column that don't have the non-numeric values of the original one. Can someone help?

[B_Albuquerque · Accepted solution]

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

[Anonymous · Accepted solution]

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

[B_Albuquerque]

Thanks, it worked!

[mdannemiller]

Create the new column, set the values of the new column equal to the old column, then change the type of the new column to text.

[B_Albuquerque · Accepted solution]

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