Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to Solution.
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!
Hi @curiouspbix0 ,
Is your issue solved now?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
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!
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
That would not help as resultant would get rid of decimal itself retrieving just numbers
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.