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.

rweisssieker-xp Updated

File contents

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.

rweisssieker-xp/powerbi-codex-plugin/tree/main/plugins/powerbi-business-intelligence/skills/powerbi-dax-test-harness commit 01290d7665

Frequently asked questions

npx skillmds@latest add rweisssieker-xp/powerbi-dax-test-harness