Forum Discussion
Solved
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 floorsp...
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
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
Yes, correct. Sorry, forgot the record translation.
jdevalk77 OK, I edited my original reply with what I believe to be the answer.
This is great, many thanks for your fast repsonse.
Much appreciated.