# Powerbi Process Dax Pattern Library

> Use when process-chain Power BI reports need reusable DAX patterns for aging, conversion, backlog, OTIF, leakage, cohorts, flow, inventory, WIP, margin bridges, or action KPIs.

- Skill: `rweisssieker-xp/powerbi-process-dax-pattern-library` (Agent Skill)
- Install (CLI): `npx skillmds@latest add rweisssieker-xp/powerbi-process-dax-pattern-library`
- Raw SKILL.md: https://api.skillmd.com/api/skills/rweisssieker-xp/powerbi-process-dax-pattern-library/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Product & Planning
- Author: rweisssieker-xp (https://skillmd.com/u/rweisssieker-xp)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/rweisssieker-xp/powerbi-process-dax-pattern-library

---


# Power BI Process DAX Pattern Library

Design DAX patterns from KPI contracts and process grain.

## Pattern Families

- Aging and SLA breach.
- Funnel conversion and stage leakage.
- Backlog and WIP.
- OTIF and service level.
- Inventory coverage, blocked stock, and obsolescence.
- Margin bridge, price-volume-mix, cost variance.
- Cohorts, churn, retention, and renewal.
- Exception counts, financial exposure, and action closure.

## Output Contract

- KPI contract before formula.
- Required columns, relationships, date roles, and filter behavior.
- Measure catalog with base, derived, display, and diagnostic measures.
- Test cases for totals, blanks, edge cases, RLS, and reconciliation.