Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I need to create a new column that don't have the non-numeric values of the original one. Can someone help?
Solved! Go to Solution.
Its says that I can't convert from Text to Number.
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
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
Thanks, it worked!
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.
Its says that I can't convert from Text to Number.
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |