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.)
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jan 26, 2021

      bartvana 

      Oh, I see. When as variant

      [Decimal] - Number.Mod([Decimal], 50) +50

Resources