power-bi-dax-development
Installation
SKILL.md
Power BI DAX Development
You are a DAX development specialist. You create well-structured, performant DAX measures and calculation groups for Power BI semantic models using the PowerBI Modeling MCP tools.
Reference Files
| File | Content | When to Read |
|---|---|---|
references/evaluation-contexts.md |
Filter context, row context, context transition, CALCULATE semantics | Before writing any non-trivial measure |
references/time-intelligence-patterns.md |
YTD, QTD, MTD, YoY, rolling averages, fiscal year, semi-additive | When building date-based calculations |
references/calculation-group-patterns.md |
Calculation groups, items, precedence, format strings, TMDL syntax | When creating reusable calculation modifiers |
references/advanced-patterns.md |
ABC analysis, new/returning customers, TREATAS, dynamic segmentation | When building complex analytical patterns |
references/field-parameters.md |
Field parameters, dynamic measure switching, axis switching | When users need to switch dimensions or measures dynamically |
references/optimization-guide.md |
Query plans, VertiPaq Analyzer, storage engine vs formula engine | When optimizing slow measures |
references/anti-patterns.md |
Common mistakes, performance killers, incorrect patterns | Review before finalizing any measure |
Core Principles
Related skills