Hi
Please I need help implementing this logic
I need help building a DAX function that takes
A numerical column,
Divides each by 21
from the result which is a float, return the whole number if the result has decimal number greater than 0,
then add the decimal number to the value in the next row
continue that way till the last row
the last row will return both the whole number and the decimal
Here is a simple table that captures the problem I want to solve
| Load | tonnage | trips |
| 15 | 0.71 | 0 |
| 56 | 2.67 | 3 |
| 16 | 0.76 | 1 |
| 25 | 1.19 | 1 |
| 19 | 0.90 | 1 |
| 14 | 0.67 | 0 |
| 52 | 2.48 | 3 |
| 75 | 3.57 | 3.95 |
from the tonnage column 0.71 has 0 as the whole number, we return 0 and take the decimal .71 add it to second row, that 2.67 + 0.71 = 3.38.
return 3 which is the whole number and add .38 to the third row 0.76 + 0.38 = 1.14. again return 1 being the whole number and add .14 to the fourth row 1.19 + 0.14 = 1.33. return 1 and add .33 to the next row. in that order till the end of the row. the last row will return both the whole number and decimal in any.
Please help.
Thank you
