Forum Discussion
Truckload efficiency
I do have a challenge;
I'd like to calculate the load efficiency per truckride. I do have a table with ridenumber, parcel/pallet category and quantity and the idea is to calculate the need floorspace known that a pallet uses 1,08 m². To keep it simple we calculated that 16 parcels uses the same floorspace as 1 pallet. So in case of let's say 8 pallets and 14 parcels per ride, the total floorspace would be (8*1,08) + ((14/16)*1,08) = 9,585 m²
I do have multiple rows that contains parcel and pallet data like:
| Ridenumber | Parcel_Pallet | Quantity_PCR |
| 52593 | Colli | 4 |
| 52593 | Pallet | 2 |
| 52593 | Pallet | 1 |
| 52593 | Pallet | 1 |
| 52593 | Colli | 1 |
| 52593 | Pallet | 1 |
| 52593 | Pallet | 1 |
| 52593 | Colli | 6 |
| 52593 | Pallet | 1 |
| 52593 | Colli | 1 |
| 52593 | Colli | 2 |
| 52593 | Pallet | 1 |
And of course I do have more ridenumbers.
Who could help me? Thanks in advance.
jdevalk77 If a Colli a parcel then maybe this. PBIX below signature.
Measure = VAR __Pallet = 1.08 VAR __Parcel = __Pallet / 16 VAR __Table = ADDCOLUMNS( SUMMARIZE('Table', [Ridenumber], 'Table'[Parcel_Pallet], "__Quantity", SUM('Table'[Quantity_PCR])), "__M2", IF([Parcel_Pallet] = "Colli", [__Quantity] * __Parcel, [__Quantity] * __Pallet) ) VAR __Result = SUMX( __Table, [__M2] ) RETURN __Result
4 Replies
jdevalk77 If a Colli a parcel then maybe this. PBIX below signature.
Measure = VAR __Pallet = 1.08 VAR __Parcel = __Pallet / 16 VAR __Table = ADDCOLUMNS( SUMMARIZE('Table', [Ridenumber], 'Table'[Parcel_Pallet], "__Quantity", SUM('Table'[Quantity_PCR])), "__M2", IF([Parcel_Pallet] = "Colli", [__Quantity] * __Parcel, [__Quantity] * __Pallet) ) VAR __Result = SUMX( __Table, [__M2] ) RETURN __ResultYes, correct. Sorry, forgot the record translation.
jdevalk77 OK, I edited my original reply with what I believe to be the answer.
