# Powerbi Dax Test Harness

> Use when DAX measures need test cases, expected totals, edge cases, time-intelligence validation, RLS context checks, or reconciliation against source totals.

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

---


# Power BI DAX Test Harness

Use this skill before accepting generated or refactored DAX.

## Test Areas

- Base totals against source totals.
- Edge cases: blanks, zero denominator, inactive records, future dates, missing dimensions.
- Time intelligence: YTD, MTD, rolling periods, fiscal calendars, prior year.
- Filter context: slicers, drillthrough, hierarchy levels.
- RLS contexts: allowed user, restricted user, denied user.
- Regression: before/after measure result comparisons.

## Output Requirements

- Provide test name, filter context, expected result, tolerance, source of truth, and pass/fail criteria.
- Treat untested DAX as draft.