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 ?

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!

Text to > 2 Decimals | Microsoft Fabric Community

5 Replies

RJ251997
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
mahoneypat
Microsoft Employee
5 years ago
Not sure what you mean. Can you provide some sample text values you are converting to text? Are you using the Number.FromText function?

Pat
v-kelly-msft
Community Support
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!
v-kelly-msft
Community Support
5 years ago
Hi curiouspbix0 ,

Is your issue solved now?

Best Regards,
Kelly

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

Forum Discussion

Text to > 2 Decimals

5 Replies

Related content

Filtering text with > or <

Decimal Precision

Can't convert text to decimal

Eventstream -> KQL. How to convert string to decimal number?

Split decimal number from text