Tools
Calculators run in your browser and compare your result to the typical range stated on the KPI page. All 22 KPI pages have a calculator and a DAX generator where you enter your own table and column names.
Browser tool
Model Compare
Two versions of a model, every added, removed and changed table, measure, relationship and role, with a DAX line diff.
Browser tool
DAX Lint
Paste measures and check them for division without DIVIDE, IFERROR, FILTER over whole tables and more.
Browser tool
Process Behavior Chart
Paste a KPI series and get XmR limits from a baseline you choose, with every signal marked.
Browser tool
Rate Comparison
Is this year's TRIR really better? Exact ranges for two incident rates and a test of the change.
Browser tool
Fiscal Calendar Generator
A 4-4-5, 4-5-4 or 5-4-4 calendar as a DAX calculated table, with every 53-week year shown before you paste it.
KPI Calculators and DAX Generators
Nothing matches that. Try a shorter word.
Production 9
| KPI | Formula | Open |
|---|---|---|
| Capacity Utilization | Actual output ÷ maximum practical capacity | Calculator DAX |
| Changeover Time (SMED) | Time from last good unit of the previous run to first good unit of the next run | Calculator DAX |
| Cycle Time | Run time ÷ units produced | Calculator DAX |
| MTBF (Mean Time Between Failures) | Total operating time ÷ number of failures | Calculator DAX |
| MTTR (Mean Time to Repair) | Total repair time ÷ number of repairs | Calculator DAX |
| OEE (Overall Equipment Effectiveness) | Availability × Performance × Quality | Calculator DAX |
| Schedule Attainment | Units produced ÷ units scheduled (per line, per week) | Calculator DAX |
| Takt Time | Available production time ÷ customer demand | Calculator DAX |
| Unplanned Downtime % | Unplanned downtime minutes ÷ total planned production minutes | Calculator DAX |
Quality 3
| KPI | Formula | Open |
|---|---|---|
| Defect PPM (Parts per Million) | (Defective units ÷ total units produced) × 1,000,000 | Calculator DAX |
| First Pass Yield (FPY) | Units passing a process step correctly on the first attempt ÷ total units started | Calculator DAX |
| Scrap Rate | Scrap units (or scrap cost) ÷ total units produced (or total cost) | Calculator DAX |
Delivery 3
| KPI | Formula | Open |
|---|---|---|
| On-Time Delivery (OTD) | Orders delivered on or before the promised date ÷ orders due | Calculator DAX |
| OTIF (On Time in Full) | Orders delivered on time AND at full ordered quantity ÷ orders due | Calculator DAX |
| Past-Due Backlog | Count (or $ value) of open orders past their promised date | Calculator DAX |
Safety 1
| KPI | Formula | Open |
|---|---|---|
| TRIR (Total Recordable Incident Rate) | Recordable incidents × 200,000 ÷ total hours worked | Calculator DAX |
Inventory 2
| KPI | Formula | Open |
|---|---|---|
| Inventory Days on Hand | (Average inventory value ÷ COGS) × 365 | Calculator DAX |
| Inventory Turns | Cost of goods sold ÷ average inventory value | Calculator DAX |
Financial 1
| KPI | Formula | Open |
|---|---|---|
| 4-Wall Margin | (Plant revenue - plant-controllable costs) ÷ plant revenue | Calculator DAX |
Labor 3
| KPI | Formula | Open |
|---|---|---|
| Absenteeism Rate | Unplanned absence hours ÷ total scheduled hours | Calculator DAX |
| Labor Productivity | Units produced ÷ total labor hours | Calculator DAX |
| Overtime Percentage | Overtime hours ÷ total hours worked | Calculator DAX |