Forum Discussion
Helper VValue from text to type number
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
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/578380https://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
1 Reply
v-piga-msftResident Rockstar
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/578380https://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