Error to convert a decimal column to text

[Rigoleto]

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?

[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

[v-danhe-msft · Accepted 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