Forum Discussion
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!
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
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 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!