Keeping Trailing 0's with Text.From

[Chaucer]

I'm trying to create a new column in power query that will hold some descriptive value metrics of our products.

if [SKUCostPerText] = "perbag"
then "£" & Text.From([Price per Bag]) & " /bag"
else if [SKUCostPerText] = "perm3"
then "£" & Text.From([Price per m3]) & " /m3"
else "£" & Text.From([Price Per Tonne]) & " /Tonne"

The above works, but it removes the trailing 0's in the Price fields. I.E. 2.20 becomes 2.2.
Any idea's of an easy way to solve?
Thanks

[edhans · Accepted solution]

You will need to mess with it a bit. This works in the scenario below:

if Text.Contains([Custom], ".") 
then Text.BeforeDelimiter([Custom],".") & "." & Text.Start(Text.AfterDelimiter([Custom],".") & "00", 2)
else [Custom] & ".00"

Column 1 is a real number. Custom is converted to text with Text.From. Custom.1 makes sure it always has two decimal places, and is the formula above.

[amitchandak]

@Chaucer , Try using text.format, to keep it a format

https://docs.microsoft.com/en-us/powerquery-m/text-format

[Chaucer]

I think I may need more help than that I'm afraid 🙂

Don't suppose I could bug you for an example of text.format for my use case?

[Greg_Deckler]

@ImkeF @edhans