Forum Discussion

baiju's avatar
baiju
Frequent Visitor
9 years ago
Solved

Cannot convert a negative text to decimal

Hi,   I am new to power bi. I have a column which have decimal values. But, the datatype is text. When I tried to convert the datatype to decimal power-bi query editors throws below error.   Data...
  • arify's avatar
    arify
    9 years ago

    I have a feeling that that "−" character isn't same as "-". As you can see, it's a bit wider. Did you get from Web.Page? Maybe you can do "Right click on columns > Replace Values" and replace "−"s with "-"s.

arify's avatar
arify
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

I have a feeling that that "−" character isn't same as "-". As you can see, it's a bit wider. Did you get from Web.Page? Maybe you can do "Right click on columns > Replace Values" and replace "−"s with "-"s.

rizwan_ahmed's avatar
rizwan_ahmed
Regular Visitor
8 years ago

Thanks arify,

it worked for me as well.

 

Kind Regards