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 am using the FORMAT() in order to convert a decimal column but, this values has being returning
"0tri0g"
Any idea why I am getting this value?
Solved! Go to Solution.
Hi @Rigoleto,
Based on my test, the “orti0g” occurred may due to you have entered the wrong parameter in function “FORMAT”. If you want to convert your decimal number to text, you can use this code:
Column = FORMAT([your column],"General Number") like the below picture:
Reference: https://msdn.microsoft.com/en-us/query-bi/dax/format-function-dax
Regards,
Daniel He
Hi @Rigoleto,
could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
Hi @Rigoleto,
Based on my test, the “orti0g” occurred may due to you have entered the wrong parameter in function “FORMAT”. If you want to convert your decimal number to text, you can use this code:
Column = FORMAT([your column],"General Number") like the below picture:
Reference: https://msdn.microsoft.com/en-us/query-bi/dax/format-function-dax
Regards,
Daniel He
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 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |