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, expanded tables, ALLSELECTED | Before writing any non-trivial measure |
references/time-intelligence-patterns.md |
YTD, QTD, MTD, WTD, YoY, rolling averages, fiscal year, semi-additive, calendar-based TI | 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, RANK, ROWNUMBER, WINDOW/INDEX/OFFSET | 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, FE/SE architecture, CALCULATE optimization, iterators, composite models, Direct Lake, debugging workflow | When optimizing slow measures or debugging |
references/anti-patterns.md |
19 common mistakes, performance killers, incorrect patterns, dynamic format strings | Review before finalizing any measure |
references/visual-calculations.md |
Visual calculations: RUNNINGSUM, MOVINGAVERAGE, PREVIOUS, NEXT, COLLAPSE, templates | When user needs visual-specific calculations (running sums, moving averages) |
references/user-defined-functions.md |
UDF syntax, reusable parameterized DAX logic, TMDL expressions [Preview] | When user needs reusable function definitions or asks about UDFs |