Power Bi Dax Optimization
This DAX optimization prompt does the heavy lifting of performance analysis that most Power BI developers skip. It systematically checks for expensive context transitions, identifies repeated calculations that should be variables, and flags inefficient function choices like COUNT over COUNTROWS. You feed it a slow DAX formula and get back an optimized version with variables, proper error handling, and clear comments explaining every change. The four-step analysis framework catches both obvious performance killers and subtle maintainability issues that cause problems months later when someone else inherits your measures.
- skills.sh installs
- 9.2K
- GitHub stars
- 41K
- last updated
- Aug 21, 2026
Install
$ npx -y skills add github/awesome-copilot --skill power-bi-dax-optimization --agent claude-codeInstalls into .claude/skills of the current project.
Files
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)
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/github/awesome-copilot
- Categories
- Git & Pull Requests, AI & Agent Building, Debugging
More from github/awesome-copilot
All 318- Aspnet Minimal Api Openapi9.2K
- Finnish Humanizer9.2K
- Arch Linux Triage9.1K
- Breakdown Epic Pm9.1K
- Quasi Coder9.1K
- Technology Stack Blueprint Generator9K
- Create Technical Spike9K
- Microsoft Skill Creator9K
- Snowflake Semanticview9K
- Finalize Agent Prompt9K
- Fluentui Blazor9K
- Vscode Ext Commands9K
- Power Bi Model Design Review9K
- Aspire9K
- Csharp Nunit9K
- Copilot Instructions Blueprint Generator9K
- Breakdown Epic Arch9K
- Remember Interactive Programming9K
- Convert Plaintext To Md9K
- Github Copilot Starter9K
- Repo Story Time9K
- Create Github Issues For Unmet Specification Requirements8.9K
- Create Github Pull Request From Specification8.9K
- What Context Needed8.9K
Recommended
More Git & Pull Requests
aspnet-minimal-api-openapigithub/awesome-copilotCreate ASP.NET Minimal API endpoints with proper OpenAPI documentation9.2Kskills.sh installsarch-linux-triagegithub/awesome-copilotTriage and resolve Arch Linux issues with pacman, systemd, and rolling-release best practices.9.1Kskills.sh installsbreakdown-epic-pmgithub/awesome-copilotPrompt for creating an Epic Product Requirements Document (PRD) for a new epic. This PRD will be used as input for generating a technical architecture specifica9.1Kskills.sh installsquasi-codergithub/awesome-copilotExpert 10x engineer skill for interpreting and implementing code from shorthand, quasi-code, and natural language descriptions. Use when collaborators provide i9.1Kskills.sh installstechnology-stack-blueprint-generatorgithub/awesome-copilotComprehensive technology stack blueprint generator that analyzes codebases to create detailed architectural documentation. Automatically detects technology stac9Kskills.sh installscreate-technical-spikegithub/awesome-copilotCreate time-boxed technical spike documents for researching and resolving critical development decisions before implementation.9Kskills.sh installs