Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello all. I have a column of data that evaluates as text. There are text data and value data (stored as text). How can I convert the value as text into a decimal value? Tried searching the board and could not find a solution.
Here is an example: (current data) and what I'd like to accomplish
Current Data | Desired Results | |
Apples | null | |
5.34 | 5.34 | |
Bananas | null | |
0.234 | 0.234 | |
Oranges | null |
Thanks for any and all responses!
Jim
Solved! Go to Solution.
Hi @JimB-GA,
New a calculated column.
result column = IF ( ISERROR ( VALUE ( 'Test data'[Data] ) ), BLANK (), VALUE ( 'Test data'[Data] ) )
Best regards,
Yuliana Gu
Hi @JimB-GA,
New a calculated column.
result column = IF ( ISERROR ( VALUE ( 'Test data'[Data] ) ), BLANK (), VALUE ( 'Test data'[Data] ) )
Best regards,
Yuliana Gu
Thank you Yuliana.
I had tried something similar earlier but ran into syntax problems. Your solution works perfectly.
Regards
Jim Blackburn
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |