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.
I'm having an issue in excels power query.
I can not figure out how to always show two decimal places.
For example, in excel it displays like this which is perfect
In Power Query It displays like this
Power Query removes the second decimal if its a zero. I'm trying to use this as a lookup by converting it to text as its my only unique number
Solved! Go to Solution.
Hi @Anonymous,
use the function Number.ToText which converts a number to text with defined format.
In your case it would be:
Table.AddColumn(#"Changed Type", "Column1 As Formated Text", each Number.ToText([Column1], "0.00"), type text)
And a screenshot with sample data:
Hi @Anonymous,
use the function Number.ToText which converts a number to text with defined format.
In your case it would be:
Table.AddColumn(#"Changed Type", "Column1 As Formated Text", each Number.ToText([Column1], "0.00"), type text)
And a screenshot with sample data:
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.