Taking the whole number and adding the decimal to the next row in DAX
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
Count of events with time constraints
Hi Community, I need some help with building a calculated column. Here's the scenario: if 4 records/rows (events) happened to the same entity within 4 hours I need to flag those events. example data: Entity | Event | Desired Flag 123 | 3/17/2020 2:04:00 AM | No 123 | 3/17/2020 3:20:00 AM | No 456 | 3/17/2020 9:00:00 AM | Yes 456 | 3/17/2020 9:40:00 AM | Yes 456 | 3/17/2020 10:30:00 AM | Yes 456 | 3/17/2020 11:10:00 AM | Yes 456 | 3/20/2020 12:00:00 PM | No Thanks.