If you would have pointed this out to the developers at Lotus 1-2-3, they would have conceded that they really meant =ROUNDTOWARDZERO. theapurva @drossi - the format mask should be "[$-en-GB]#.00". The other way you can tie a custom tooltip page to your charts is to manually set it. Summary: Microsoft Scripting Guy, Ed Wilson, talks about using strings to format the display of decimal places in Windows PowerShell. Check out the new Power Platform Communities Front Door Experience. In Power Query, a custom column formula of =Number.RoundTowardZero([Number],[Digits]) will replicate TRUNC. Missing Decimals with Power Query Append - Microsoft Community iAm_ManCat Here is an example of changing a number that has two decimal places to a number that contains a single decimal place: All I need to do is use the pound sing ( # ) where I want a digit to appear. I now have hit some complications as when I make mileage a text column (as opposed to a decimal) to allow the code to work, it changes the values to something crazy. Now you should check all columns and apply a dummy-transformation. Formatting PowerShell Decimal Places - Scripting Blog This can cause a performance issue. Here is the quick guide to those options to resolve ties: At this point, the new column will be rounding just like Excel. SudeepGhatakNZ* AaronKnox Let us know in theCommunity Feedbackif you have any questions or comments about your community experience.To learn more about the community and your account be sure to visit ourCommunity Support Areaboards to learn more! Find out about what's going on in Power BI by reading blogs written by community members and product staff. In both Excel and Power Query rounding 2.9 will give you 2. We are so excited to see you for the Microsoft Power Platform Conference in Las Vegas October 3-5 2023! Power Apps Samples, Learning and Videos GalleriesOur galleries have a little bit of everything to do with Power Apps. The default method used by Power Query is to resolve ties by rounding towards even. Mira_Ghaly* edgonzales website are provided "as is" and we do not guarantee that they can be used in all If an * is at the end of a user's name this means they are a Multi Super User, in more than one community. I'm so sorry. OliverRodrigues RobElliott The CEILING.MATH function in Excel will always round up to the next multiple of the significance argument. Please note this is not the final list, as we are pending a few acceptances. Ideally, you want to store values up to two decimal places.