topic Re: Days of supply (DFC) Measure in DAX Commands and Tips

Days of supply (DFC) Measure

Hossam_Khattab — Fri, 24 Apr 2026 13:14:10 GMT

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?

Re: Days of supply (DFC) Measure

Juan-Power-bi — Fri, 24 Apr 2026 19:54:13 GMT

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.

Re: Days of supply (DFC) Measure

FBergamaschi — Sat, 25 Apr 2026 11:32:44 GMT

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

Re: Days of supply (DFC) Measure

Hossam_Khattab — Sat, 25 Apr 2026 20:41:29 GMT

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:

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.
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.

Re: Days of supply (DFC) Measure

v-priyankata — Tue, 19 May 2026 04:34:14 GMT

Hi Hossam_Khattab

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

FBergamaschi Juan-Power-bi Thanks for the inputs.

You are expecting DFC in daily basis not weekly and expecting below calculation. DFC=Full Covered Days+(Remaining Inventory/Next Uncovered Day Demand)

I have done changes for existing "Matrix Values" and "DFC" measures. Please refer below output snap.

DFC =
VAR CurrentDate =
    MAX('Date'[Date])
VAR CurrentInventory =
    [Dynamic Projected Inventory]
VAR FutureDates =
    FILTER(
        ALL('Date'[Date]),
        'Date'[Date] > CurrentDate)
VAR DemandTable =
    ADDCOLUMNS(
        FutureDates,
        "DailyDemand",
            CALCULATE([Dynamic Selected Demand]),
        "CumDemand",
            VAR FutureDate = 'Date'[Date]
            RETURN
                CALCULATE(
                    [Dynamic Selected Demand],
                    FILTER(
                        FutureDates,
                        'Date'[Date] <= FutureDate
                    )
                )
    )
VAR FullDaysCovered =
    COUNTROWS(
        FILTER(
            DemandTable,
            [CumDemand] <= CurrentInventory
        )
    )
VAR FirstUncoveredDate =
    MINX(
        FILTER(
            DemandTable,
            [CumDemand] > CurrentInventory
        ),
        'Date'[Date]
    )
VAR CumDemandBeforeUncovered =
    MAXX(
        FILTER(
            DemandTable,
            'Date'[Date] < FirstUncoveredDate
        ),
        [CumDemand]
    )
VAR RemainingInventory =
    CurrentInventory
        - COALESCE(CumDemandBeforeUncovered,0)
VAR UncoveredDayDemand =
    MAXX(
        FILTER(
            DemandTable,
            'Date'[Date] = FirstUncoveredDate
        ),
        [DailyDemand]
    )
VAR FractionalDay =
    DIVIDE(
        RemainingInventory,
        UncoveredDayDemand,
        0
    )
VAR FinalDFC =
    FullDaysCovered + FractionalDay
RETURN
IF(
    CurrentInventory <= 0,
    0,
    ROUND(FinalDFC,1)
)

Matrix Values =
VAR ElementsInContext = VALUES('Matrix Rows'[Element])
VAR IsLowestLevel = ISINSCOPE('Matrix Rows'[Element])
RETURN
IF(
    NOT IsLowestLevel,
    [Dynamic Projected Inventory],
    SUMX(
        ElementsInContext,
        SWITCH(
            'Matrix Rows'[Element],
            "Starting Inventory", CALCULATE(SUM('drp_femcare_spi_4'[Starting Inventory])),
            "Quality Inventory", CALCULATE(SUM('drp_femcare_spi_4'[Quality_Inventory])),
            "Shipment Notification", CALCULATE(SUM('drp_femcare_spi_4'[Shipment_Notification])),
            "PCH Order", CALCULATE(SUM('drp_femcare_spi_4'[PCH_Order])),
            "Planned Order", CALCULATE(SUM('drp_femcare_spi_4'[Planned_Order])),
            "Standard Production Fixed", CALCULATE(SUM('drp_femcare_spi_4'[Standard_Production_Fixed])),
            "Standard Production Planned", CALCULATE(SUM('drp_femcare_spi_4'[Standard_Production_Planned])),
            "Customer Order", CALCULATE(SUM('drp_femcare_spi_4'[Customer_Order])),
            "Forecast Distribution Demand",
            CALCULATE(SUM('drp_femcare_spi_4'[Forecast_Distribution_Demand])) * [Demand Multiplier Value],
            "Forecast",
            CALCULATE(SUM('drp_femcare_spi_4'[Forecast]))
            * [Demand Multiplier Value],
            "Projected Inventory", [Dynamic Projected Inventory],
            "Days Supply",
                CALCULATE(
                    [DFC],
                    REMOVEFILTERS('Matrix Rows'[Element])
                ),
                BLANK()
        )
    )
)

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

Thanks.

Re: Days of supply (DFC) Measure

v-priyankata — Fri, 08 May 2026 09:42:52 GMT

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.

Re: Days of supply (DFC) Measure

v-priyankata — Tue, 12 May 2026 04:03:28 GMT

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.