Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Convert minus number

How can I convert -1.5 of type text to number?  I tried with value() but getting error :   Cannot convert '-1.5' of type text to type number.    
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    You can use the CONVERT() function keeping the second argument as Double. 

    For Example: 

    ConvertToDecimal = CONVERT(ALL('Table1'[Column1]),DOUBLE)
     
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try to change the data type to number(Power Query). Is it giving error

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Can you explain more with example?