Hi All,
thank you for reading this first!
i hope you could help me
i am writing a DAX measurment to reflect the number of container we will use
assume every 11000 KG cargo will need 1 Container
example, 7500 KG, it will need 1 Container, 15000 KG, it will need 2 container and 19000KG it wil need 2 Container as well
So, i got the sample data as below
| Lane | BKD | ETA | WEIGHT_CHARGEABLE_KG |
| BOMHYD | 10/05/2023 22:00 | 11/05/2023 14:45 | 200 |
| BOMHYD | 10/05/2023 22:00 | 11/05/2023 14:45 | 300 |
| BOMHYD | 10/05/2023 22:00 | 11/05/2023 14:45 | 400 |
| BOMHYD | 10/05/2023 22:00 | 11/05/2023 14:45 | 100 |
| BOMHYD | 10/05/2023 22:00 | 11/05/2023 14:45 | 200 |
| BOMHYD | 10/05/2023 22:00 | 11/05/2023 14:45 | 100 |
| HYDDEL | 11/05/2023 20:00 | 13/05/2023 12:36 | 4800 |
| HYDDEL | 11/05/2023 20:00 | 13/05/2023 12:36 | 8210 |
| HYDDEL | 11/05/2023 20:00 | 13/05/2023 12:36 | 5810 |
| HYDDEL | 11/05/2023 20:00 | 13/05/2023 12:36 | 1250 |
| HYDDEL | 11/05/2023 20:00 | 13/05/2023 12:36 | 1300 |
| BOMHYD | 11/05/2023 22:00 | 12/05/2023 14:45 | 200 |
| BOMHYD | 11/05/2023 22:00 | 12/05/2023 14:45 | 200 |
| BOMHYD | 11/05/2023 22:00 | 12/05/2023 14:45 | 200 |
| BOMHYD | 11/05/2023 22:00 | 12/05/2023 14:45 | 3300 |
| BOMHYD | 11/05/2023 22:00 | 12/05/2023 14:45 | 300 |
my prefered result will be
| Lane | WEIGHT_CHARGEABLE_KG | Number of Container |
| BOMHYD | 5500 | 2 |
| HYDDEL | 21370 | 2 |
the BOMHYD lane, if based on the weight - 5500 KG, it should be 1 Container, but, not, I want it show 2 container because we put the BKD(departure date) in consideration.
for BKD 10/05, we have 1300 KG cargo which required 1 container, and BKD 11/05, we have 4200 KG, whcih required 1 container as well
so, i want to result show 2 Container in there, not sure if anyone could help me?
Thank you!
