Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
38 | |
26 | |
20 | |
15 | |
8 |
User | Count |
---|---|
69 | |
47 | |
46 | |
20 | |
16 |