Forum Discussion
Helper IIKeeping Trailing 0's with Text.From
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
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.
4 Replies
- edhans
Community Champion
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
Super User
Chaucer , Try using text.format, to keep it a format
ChaucerI 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
