topic Re: Calculating stocks depending on best before dates in DAX Commands and Tips

Calculating stocks depending on best before dates

Aphax1477 — Mon, 04 Mar 2024 11:36:16 GMT

Hello,

I need some help with the following problem:

We have products with different best before dates. I would like to calculate how long the respective stock/best-before date will last and how much stock may need to be disposed of, given the current sales rate. For me, the start time of sales for the following BBDs is the crucial point here that needs to be calculated.

In this example here, the sale of the product with the first best before date must be stopped on 16/04, as the best before date has been reached and the sale of the next best before date batch begins.

Does anyone have any ideas on this? Many thanks in advance.

Re: Calculating stocks depending on best before dates

Greg_Deckler — Mon, 04 Mar 2024 14:11:18 GMT

Aphax1477 I'm unclear what you are asking here. When you say the "sale of the product must be stopped" what does that mean exactly?

Re: Calculating stocks depending on best before dates

Aphax1477 — Mon, 04 Mar 2024 14:19:32 GMT

Greg_Deckler

This means that Today=Bestbeforedate, we can no longer sell this batch of the product.
From now on, we can only sell the next batch of this product.

Hope this helps to explain the problem better.

Re: Calculating stocks depending on best before dates

Greg_Deckler — Mon, 04 Mar 2024 14:22:55 GMT

Aphax1477 OK, I *get* that much. The question is, what does that actually mean in terms of your report. Is there a particular calculation that you need, like a measure or ???

Re: Calculating stocks depending on best before dates

Aphax1477 — Mon, 04 Mar 2024 17:11:48 GMT

I need a calculation of when the sale of the 2nd batch starts? Under the condition that the end of sales of the 1st batch can be either the best-before date or the out of stock date, whichever comes first.

Measure: Start date for sales

Sales Start Batch 1 = Today
Sales Start Batch 2 = ?
(Sales Start Batch 3 = ? ....)