topic Re: Round number to get the whole part in DAX Commands and Tips

Round number to get the whole part

pagliaci — Thu, 01 Sep 2022 13:39:42 GMT

Hi, I have 2 columns: Y is a decimal number, and "#maint. needed" should tell me how many actions I need to do in base on the number before decimals of the Y column

#maint. needed = LEFT(ZMPF[Y], 1)

What I want is this result:

y= 0,005 --> # maint =0

y= 0,9 --> # maint =0

y= 1,8 --> # maint =1

y= 2,99 --> # maint =2

But my maint column is doing, like the picture:

y= 0,005 --> # maint =5

y= 0,03 --> # maint =3

I suspect it does that because of the scientific terminology, but I don't know how to fix it.

Re: Round number to get the whole part

tamerj1 — Thu, 01 Sep 2022 14:20:25 GMT

Hi pagliaci

use ROUNDDOWN function

Re: Round number to get the whole part

pagliaci — Thu, 01 Sep 2022 14:21:56 GMT

It doesn't work, I tried

Re: Round number to get the whole part

pagliaci — Thu, 01 Sep 2022 14:22:37 GMT

I got it, I needed to use TRUNC ()!! Thanks 🙂

Re: Round number to get the whole part

tamerj1 — Thu, 01 Sep 2022 14:23:46 GMT

Did you check the data type?