Days of supply (DFC) Measure

[Hossam_Khattab]

I don't know how to apply the DFC in daily basis (not weekly)?!

the day supply shown here is calculated based on taking averge of the next 28 days but this is not acually what I want to apply.
Any help?

[v-priyankata]

Hi @Hossam_Khattab 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@FBergamaschi @Juan-Power-bi Thanks for the inputs.

What you’re trying to calculate (true daily Days Forward Coverage) cannot be achieved using an average-based approach like dividing inventory by the average of the next 28 days. That method assumes demand is evenly distributed, which doesn’t reflect real daily fluctuations. Instead, the correct approach is to start with the projected inventory of the current day, then move to the next day and subtract demand day by day until the inventory is exhausted.

As you subtract future daily demand, you count how many full days are completely covered, and if the inventory runs out partway through a day, you calculate a fraction for that final day (remaining inventory divided by that day’s demand). This gives you a realistic result such as 2.5 days instead of an averaged estimate, and ensures the calculation reflects actual daily demand patterns rather than a smoothed approximation.

If there are any deviations from your expectation please let us know we are happy to address.

Thanks.

[v-priyankata]

Hi @Hossam_Khattab 

Thank you for reaching out to the Microsoft Fabric Forum Community.

I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.

[v-priyankata]

Hi @Hossam_Khattab 

Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.

[Hossam_Khattab]

This is more clarification for the problem,
The dashboard here shows a projected inventory (a dynamic projected inventory which is calculated for every day based on the elements above it)

• Dynamic Projected Inventory = Dynamic Selected Supply - Dynamic Selected Demand
• Dynamic Selected Supply = Starting Inventory + Quality Inventory + Shipment Notification + PCH Order + Planned Order + Standard Production Fixed + Standard Production Planned
• Dynamic Selected Demand = Customer Order + Forecast + Forecast Distribution Demand

What I want to see is the Days Forward Coverage (DFC), it is mainly to see how many days (starting from the next day) can I supply with my currently projected inventory.
(Starting from the next day) This is because the demand of today is already taken into the calculation of the projected inventory I currently have.

This is an example to make it clear,

Days	Projected Inventory	Demand (Dynamic Selected Demand)	DFC (Days Supply)
Day 1	1000	900	2.5
Day 2	600	500	2
Day 3	400	400	1.4
Day 4	400	200	0.8
Day 5	500	500	and so on for the rest of days

So for example, Let's analyses Day 1, we have 1000 projected inventory that can cover the demand of Day 2 and Day 3 but in Day 4 the remaining projected inventory of Day 1 will be (1000-500-400=100) so it will not cover Day 4 then we take the fraction (the remaining inventory / the demand that can't be supplied) -> (100/200=0.5) 

So, the days that inventory of Day 1 can cover is 2.5 Days.

Note:

1. I don't want to use the average logic by taking the demand average of a period and dividing the inventory over it because it is not a real acual output of the days can be supplied.
2. I am working daily not weekly.

You will find the Power BI file on this google drive
https://drive.google.com/file/d/1r-cYz9bxQDo6i1_7MkhmGSmLaMg8souP/view?usp=sharing

I hope it is now clear enough and feel free to ask about any further clarification.

[FBergamaschi]

Please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Alternatively, you can share your .pbix via some cloud service and paste the link here. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.

Need help uploading data? click here

Want faster answers? click here

[Juan-Power-bi]

Hello

Can you clarify what exactly you want the Days of Supply to represent on a daily basis? The classic DOS formula is Current Stock ÷ Average Daily Demand — so if you already have stock on hand and daily sales/consumption data, it would look something like this:
daxDays of Supply =
VAR CurrentStock = SUM('Inventory'[Stock])
VAR AvgDailyDemand =
CALCULATE(
AVERAGEX(
VALUES('Date'[Date]),
[Total Demand]
),
DATESINPERIOD('Date'[Date], MAX('Date'[Date]), -28, DAY)
)
RETURN
DIVIDE(CurrentStock, AvgDailyDemand)
This uses a 28-day average as the denominator, which is pretty standard — but if you want a shorter or longer window, just change the -28.