Forum Discussion

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?

Anonymous

Not applicable

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

Frequent Visitor

9 years ago

Thanks, it worked!