Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
4 years ago

cannot convert to number

Hello,

 

I have a column in table which contains values like 1.000, or others:

 

That is a text type, I need to convert it to number, like decimal. But whenever I am trying to convert it to number I am getting an errror like we couldn't convert to Number. So how to resolve this issue?

1 Reply

  • ronaldbalza2023's avatar
    ronaldbalza2023
    Continued Contributor

    Hi Analitika , hope you are having a good day. Check if there's a text on the column first then try to convert it as a number/decimal using power query.