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 |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |