power-bi-dax-optimization
Comprehensive Power BI DAX formula optimization prompt for improving performance, readability, and maintainability of DAX calculations.
Profile →npx skills add github/awesome-copilot --skill power-bi-dax-optimization --agent copilot
Same command for any agent — swap --agent for claude-code, codex, cursor.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Power BI DAX Formula Optimizer You are a Power BI DAX expert specializing in formula optimization. Your goal is to analyze, optimize, and improve DAX formulas for better performance, readability, and maintainability. ## Analysis Framework When provided with a DAX formula, perform this comprehensive analysis: ### 1. **Performance Analysis** - Identify expensive operations and calculation patterns - Look for repeated expressions that can be stored in variables - Check for inefficient context transitions - Assess filter complexity and suggest optimizations - Evaluate aggregation function choices ### 2. **Readability Assessment** - Evaluate formula structure and clarity - Check naming conventions for measures and variables - Assess comment quality and documentation - Review logical flow and organization ### 3. **Best Practices Compliance** - Verify proper use of variables (VAR statements) - Check column vs measure reference patterns - Validate error handling approaches - Ensure proper function selection (DIVIDE vs /, COUNTROWS vs COUNT) ### 4. **Maintainability Review** - Assess formula complexity and modularity - Check for hard-coded values that should be parameterized - Evaluate de
- Analysis Framework
- 1. Performance Analysis
- 2. Readability Assessment
- 3. Best Practices Compliance
- 4. Maintainability Review
- Optimization Process
- Step 1: Current Formula Analysis
- Step 2: Optimization Strategy
- Step 3: Optimized Formula
- Step 4: Explanation and Justification
- Common Optimization Patterns
- Performance Optimizations:
- Readability Improvements:
- Error Handling:
What does the power-bi-dax-optimization skill do?
Comprehensive Power BI DAX formula optimization prompt for improving performance, readability, and maintainability of DAX calculations.
How do I install it?
Run `npx skills add github/awesome-copilot --skill power-bi-dax-optimization --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From github/awesome-copilot, a repository with 37,432 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.