Calculating to specific decimal places without rounding
Hello Community Team, I am having struggles with rounding the numbers. I don't want it to round after 2 decimals, but I am unsure of the dax grammar to make it so. Please find the snapshot. Unfortunately, explaining to the management team rounding issues, it still confuses them. I would just like the Share Change= 0.9 - 1.0 = -0.1 (not the -0.2 shown from rounding). My share formulas are: Share Change = [Current Share] - [LY Share] Current Share = var Dollars = sum('Legacy YTD'[Current Dollars]) var ACV = CALCULATE(sum('Legacy YTD'[Current Dollars]), ALL('Legacy YTD'[Supplier])) return DIVIDE(dollars*100,acv,0) LY Share = var Dollars = sum('Legacy YTD'[YA Dollars]) var ACV = CALCULATE(sum('Legacy YTD'[YA Dollars]), ALL('Legacy YTD'[Supplier])) return DIVIDE(dollars*100,acv,0) I have tried to search within here and it's not exactly working based on what I have seen for the solved solutions. Thank you in advance.Number.ExcelBin2Dec in Power Query Language M
Use Case - Excel offers many number conversion functions and BIN2DEC (Binary to Decimal) is one of them. But Power Query's M language doesn't offer this conversion function. Below are some examples when a binary number is given and Excel's BIN2DEC function is applied on that.
