A quick way to transform all the columns in one go is by highlighting them and then following the same steps. HamidBee Then the "Power Apps Ideas" section is where you can contribute your suggestions and vote for ideas posted by other community members. So in the example, I had two decimal places, but I only wanted one. The trailing zero is effectively a preferred format, not a data type. In both Excel and Power Query rounding 2.9 will give you 2. @drossi - the format mask should be "[$-en-GB]#.00". Kaif_Siddique But when I have a plan in place, I do not give it a lot of extra thought. If you have any questions, send email to me at [email protected], or post your questions on the Official Scripting Guys Forum. A quick way to transform all the columns in one go is by highlighting them and then following the same steps. zmansuri Choose the account you want to sign in with. Ankesh_49 View our Privacy Policy, Cookies Policy, and Terms of Use. You could choose to Round and then edit the function from Number.Round to Number.RoundTowardZero in the formula bar. Power Platform and Dynamics 365 Integrations, Text function - Power Apps | Microsoft Docs, Power Platform Connections Ep 11 | C. Huntingford | Thursday, 23rd April 2023, Microsoft Power Platform Conference | Registration Open | Oct. 3-5 2023. But for negative numbers, =INT(-2.1) will take you to -3. Users can see top discussions from across all the Power Platform communities and easily navigate to the latest or trending posts for further interaction. (see screenshot) For example : Have you looked in "modelling" and/or the formatting of the table in the visualisation? If you enter =ROUNDUP(-2.1,0) in Excel, you will get -3. grantjenkins Thanks very much for the idea, I'll give it a go and let you know if i get anywhere! Hey, Scripting Guy! Then the expression below (remember to use your column name instead of Column1 in the below expression): Text.Remove ( [Column1], {"0".."9"} ) And here is the result; all digits removed. Provided you choose View, Formula Bar in Power Query, you can see the code generated for each step.
