Forum Discussion

Scaffnull's avatar
Scaffnull
Icon for Helper I rankHelper I
5 years ago
Solved

Rounding whole numbers formula DAX

Hi all, Is there a way to use the DAX formula to round whole numbers by only changes of 5? So if I have 11 I want the result to be 10, if I get 14 I want the result to be 15. Appreciate the help! 
Need Help
Tips and Tricks
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    Not sure what you mean.  You can use the column or expression value in the MROUND function.  For example,

     

    NewColumn = MROUND(Table[NumberColumn], 5)

     

    Pat

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

You can use the MROUND function for that.  For example, MROUND(14, 5) = 15

 

Pat

 

  • Scaffnull's avatar
    Scaffnull
    Icon for Helper I rankHelper I
    5 years ago

    mahoneypat Thanks! And if I have rows with different values, is there a way to optimize that? For example I have 132 (want 130), 33 (want 35) and so on...

    • mahoneypat's avatar
      mahoneypat
      Icon for Microsoft Employee rankMicrosoft Employee
      5 years ago

      Not sure what you mean.  You can use the column or expression value in the MROUND function.  For example,

       

      NewColumn = MROUND(Table[NumberColumn], 5)

       

      Pat

       

      • Scaffnull's avatar
        Scaffnull
        Icon for Helper I rankHelper I
        5 years ago

        mahoneypat Simple as that! Worked like a charm. All my values that are between 1-4 rounds to either 5 or 0. (24 rounds to 25, 33 rounds to 35, 11 round to 10 etc,.) Perfect, thanks!