Forum Discussion

quyenduong's avatar
quyenduong
Icon for Helper II rankHelper II
4 years ago

Cannot change text to number in Power Query Editor

Hi there,    I have several columns (all columns with Est & Year in the header) that include null value and number like this 190,513. Power BI automatically recognizes this column as Text but not N...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

quyenduong , Can you please click error and share that

  • quyenduong's avatar
    quyenduong
    Icon for Helper II rankHelper II
    4 years ago

    Hi amitchandak , I found out that the data containing numbers always have "comma" between numbers, therefore, it fails to convert to Whole number.

     

    I saw that there is a function to replace value "," to nothing but I wonder if i can apply this for all columns containing number so I dont have to do it one by one. 

    Thank you

     

    • v-xiaotang's avatar
      v-xiaotang
      Icon for Community Support rankCommunity Support
      3 years ago

      Hi quyenduong 

      Thanks for reaching out to us.

      Usually a number column is automatically recognized as a number column, unless the number contains some spaces, then the column will be recognized as text type. Could you share a sample file for us to check? thanks

       

       

      Best Regards,

      Community Support Team _Tang

      If this post helps, please consider Accept it as the solution to help the other members find it more quickly.