Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |