Power BI - Essential Supply Chain & Procurement DAX Measures

on

Essential Supply Chain & Procurement DAX Measures

1. Inventory Management                                

Total Inventory = SUM(Inventory[Stock])

Inventory MTD = 
CALCULATE([Total Inventory], DATESMTD(DateTable[Date]))

Inventory YTD = 
TOTALYTD([Total Inventory], DateTable[Date])

Inventory LY = 
CALCULATE([Total Inventory], 
SAMEPERIODLASTYEAR(DateTable[Date]))

Inventory Turnover = 
DIVIDE(SUM(Sales[COGS]), AVERAGE(Inventory[Stock]), 0)

 Tracks stock levels and turnover efficiency across time periods.

2. Supplier Performance

On-Time Deliveries % = 
DIVIDE(
    COUNTROWS(FILTER(Supplier, Supplier[DeliveryStatus] = "On-Time")),
    COUNTROWS(Supplier),
    0
)

On-Time Deliveries YTD = 
TOTALYTD([On-Time Deliveries %], DateTable[Date])

On-Time Deliveries LY = 
CALCULATE([On-Time Deliveries %], SAMEPERIODLASTYEAR(DateTable[Date]))

Supplier Defect Rate % = 
DIVIDE(
    COUNTROWS(FILTER(Supplier, Supplier[DefectFlag] = TRUE)),
    COUNTROWS(Supplier),
    0
)

 Evaluates supplier reliability and quality trends.

3. Procurement Spend

Total Spend = SUM(Procurement[Amount])

Spend MTD = 
CALCULATE([Total Spend], DATESMTD(DateTable[Date]))

Spend YTD = 
TOTALYTD([Total Spend], DateTable[Date])

Spend LY = 
CALCULATE([Total Spend], SAMEPERIODLASTYEAR(DateTable[Date]))

Spend Variance = [Total Spend] - [Budgeted Spend]

 Monitors procurement costs and compares against budget.

4. Logistics & Distribution

Freight Cost = SUM(Logistics[FreightCost])

Freight Cost YTD = 
TOTALYTD([Freight Cost], DateTable[Date])

Delivery Accuracy % = 
DIVIDE(
    COUNTROWS(FILTER(Logistics, Logistics[DeliveryStatus] = "Accurate")),
    COUNTROWS(Logistics),
    0
)

Lead Time (Days) = 
AVERAGEX(Logistics, DATEDIFF(Logistics[OrderDate], Logistics[DeliveryDate], DAY))

 Tracks transportation costs, delivery accuracy, and lead times.

5. Risk & Sustainability

Single Supplier Dependency % = 
DIVIDE(
    COUNTROWS(FILTER(Supplier, Supplier[PrimaryVendor] = TRUE)),
    COUNTROWS(Supplier),
    0
)

Sustainable Procurement % = 
DIVIDE(
    COUNTROWS(FILTER(Procurement, Procurement[SustainableFlag] = TRUE)),
    COUNTROWS(Procurement),
    0
)

 Identifies supplier risk and sustainability metrics.

Takeaway

These measures give Supply Chain & Procurement teams time-based insights into inventory, supplier reliability, spend efficiency, logistics performance, and risk exposure. 

Comments

Post a Comment