Quick answer
Backorder Rate is commonly calculated as:
Backordered Items / Total OrdersExcel version:
=B2/C2Example table
| Metric | Example value |
|---|---|
| Numerator / current value | 120,000 |
| Denominator / base value | 400,000 |
| Backorder Rate | 30% |
How to calculate it in Excel
- Create one column for each input in the KPI formula.
- Paste the Excel formula in the result column.
- Replace B2, C2, and D2 with the cells from your own sheet.
- Format ratio KPIs as Percentage and money KPIs as Currency.
- Compare the KPI over time, by team, or by channel instead of looking at one isolated number.
Power BI DAX version
For dashboards, create a measure and adapt the table and measure names to your model.
Backorder Rate = DIVIDE([Numerator], [Denominator], 0)Tips
- Keep the numerator and denominator definitions consistent across reports.
- Document whether the KPI is monthly, quarterly, annual, trailing, or point-in-time.
- Use the same calculation logic in Excel and Power BI when comparing reports.