Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
pls try this
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |