Forum Discussion
Helper IIError to convert a decimal column to text
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?
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
2 Replies
v-danhe-msftMicrosoft Employee
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
- v-danhe-msft
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