Forum Discussion

Icon for Helper IV rank

Helper IV

5 years ago

Solved

Text to > 2 Decimals

Hello PQ Experts, On Power Query, Text when converted to Number results with only 2 decimals. How do I convert to Text to Number but retain all decimal values ?

v-kelly-msft
5 years ago
Hi curiouspbix0 ,

How do you convert to number?As tested here,it keeps all the decimals.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Icon for Helper I rank

Helper I

5 years ago

Hi curiouspbix0 ,

Go to that link its helpful for you .

https://eriksvensen.wordpress.com/2018/03/06/extraction-of-number-or-text-from-a-column-with-both-text-and-number-powerquery-powerbi/

https://eriksvensen.wordpress.com/2018/03/06/extraction-of-number-or-text-from-a-column-with-both-text-and-number-powerquery-powerbi/

Thank & Regards

Rohit Jaiswal

curiouspbix0
Helper IV
5 years ago
That would not help as resultant would get rid of decimal itself retrieving just numbers