The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
@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?
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.
@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 ???
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 = ? ....)