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 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
Solved! Go to 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou 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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting@Chaucer , Try using text.format, to keep it a format
https://docs.microsoft.com/en-us/powerquery-m/text-format
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?
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.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |