Round number to get the whole part
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.
ROUND function
Hi everyone. I am looking for a way to create a " round " function that will round the result of my measure: P4P Workshop Parts Sales = ('Workshop Parts Sales'[Workshop Parts] * (1 + P4P[P4P])) I am currently getting the following result: P4P Capacity = HIST_CAPACITY[History FTE] * (1 + P4P[P4P]) I am currently getting the following result: Regards Piotr
