Value from text to type number

[paris]

Hi All,

Could you please help me to convert from text to number in table format? I was not able to do that....

*************************

Data type change

With this data type change, your data will be store differently. This may cause a loss of data or precision. After you make this change, you can restore the column by refreshing the table. Do you want to continue?

Error

We can't automatically convert the column to Decimal Number type. 

 *************************

Then I try to do it by using fomula but I got this error. 

Cannot convert value"Volume" of type Text to type Number. 

Appreciate if you could help!

All the best,

Loveparis

[v-piga-msft · Accepted solution]

Hi @paris ,

For your requirement, you could refer to the similar threads below firstly.

https://community.powerbi.com/t5/Desktop/Cannot-Convert-value-of-type-Text-to-number/td-p/532657

https://community.powerbi.com/t5/Desktop/Cannot-convert-value-of-type-Text-to-type-Integer/td-p/5783...https://community.powerbi.com/t5/Desktop/cannot-convert-type-text-to-number/td-p/464360

If you still need help, please share some data sample which could reproduce your scenario so that we could help further on it.

Best Regrads,

Cherry