Number.Int and Number.ExcelInt functions in Power Query M Language
Use Case: There are many scenarios where we are required to extract the integer portion of a number. Hence, for 23.57 and for -45.678, the integer portions will be 23 and -45 respectively. Power Query Number functions library doesn't provide any function which can do this. Hence, we will work out a formula to make a Number.Int function.
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.
