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 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
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 |
---|---|
95 | |
94 | |
79 | |
71 | |
64 |
User | Count |
---|---|
120 | |
105 | |
99 | |
81 | |
72 |