power query custom column round

[rjmdc]

what would m code be to round down to the nearest 10?

 

[shaowu459]

For positive numbers, how about this one:

or this one:

 

[shaowu459]

for negative numbers, it depends on what you need, round towards zero or away from zero. Take -23 as an example, which one is you need, -20 or -30?

 

[rjmdc]

hi
round.down worked
thanks
i had tried but seems like i did something wrong as i didnt get the same result
when i copied your work it was perfect

what does the second example do? seems like it is a more roundabout method

i havent needed negative numbers yet

 

[shaowu459]

hi
round.down worked
thanks
i had tried but seems like i did something wrong as i didnt get the same result
when i copied your work it was perfect

what does the second example do? seems like it is a more roundabout method

i havent needed negative numbers yet

The second one works like this: Number.Mod(23,10) returns 3, 23-3 reruns 20.