Forum Discussion

bartvana's avatar
bartvana
Iron Contributor
Jan 21, 2021

MROUND in Power Query

Is there an easy alternative for MROUND() in Power Query? I know the Number.Round functions, but I find no direct alternative for MROUND()?
BI & Data Analysis
excel
power bi
  • bartvana's avatar
    bartvana
    Iron Contributor
    Jan 21, 2021

    Thanks for the link. Great solution, but a bit overly complicated for my use-case, I think (multiples of integers, instead of rounding behind the comma).

    I've been experimenting a bit more, and came up with this (for rounding up to multiples of 50)

    =Number.RoundUp([Decimal]/50)*50

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jan 21, 2021

      bartvana 

      I guess it shall be just round, not up

      =Number.Round([Decimal]/50)*50
      • bartvana's avatar
        bartvana
        Iron Contributor
        Jan 26, 2021
        Also possible, depending on the use case of course. (In my case I needed rounding up.)

Resources