Forum Discussion
B_Albuquerque
9 years agoFrequent Visitor
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?
- 9 years ago
Its says that I can't convert from Text to Number.
- Anonymous9 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
mdannemiller
9 years agoFrequent Visitor
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_Albuquerque9 years agoFrequent Visitor
Its says that I can't convert from Text to Number.