"Hey, I need some assistance, please. I have the following formula. I also have another dataset, which is a file of shipment allocations by trucks and customers. I want to implement a condition where if a customer doesn't have an order totaling $800 on a specific date, then that order will be added to the next order. In the next order, it will again check if it reaches $800, and this can take into account the data from the previous order if there was one. So, I created a pivot for the original dataset, and now I'm planning to filter the data by customer and date, so I can identify when the condition occurs. Essentially, I want to reduce the number of shipments, so it only happens if the order reaches the threshold of $800. However, it's important to note that if there's an order for less than $800, we wait for accumulation until such an order is formed.
I am currently conducting the check on a specific month in the year 2024
like this ,
customerShipments =
CALCULATETABLE(
SUMMARIZE(
'TABLE1',
'TABLE1'[customer],
'TABLE1'[date],
"Qty", SUM('TABL1'[AMOUNT])
),
'TABL1'[Year] = 2024,
'TABL1'[Month] = 2,
''TABL1'[AMOUNT] > 0
)
