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.
I converted a fixed decimal number column to text. Once converted, if the digits after the decimal were zeros, or the last digit was zero, they are being dropped from the text. How can keep the zeros after the decimal?
Solved! Go to Solution.
Try adding SUBSTITUTE function as well
so New Column = SUBSTITUTE( FIXED (TableName[1_GL_Account],2), ",", "")
Try the following formula:
New Column = FIXED (TableName[1_GL_Account],2)
FIXED function converts the number to text and keeps 2 decimal places
That worked for the decimals, but added commas to the string. Can the commas be removed also? It needs to be formatted like this: 3219001011.05
Try adding SUBSTITUTE function as well
so New Column = SUBSTITUTE( FIXED (TableName[1_GL_Account],2), ",", "")
HI @kekepania0529 ,
Can you share your sample data here so that I can try it at my end?
Thanks,
Pragati
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |