power-bi-dax-optimization
Comprehensive DAX formula analysis and optimization with performance, readability, and best-practice guidance.
- Analyzes formulas across four dimensions: performance bottlenecks, readability clarity, best-practice compliance, and maintainability challenges
- Provides step-by-step optimization strategy including variable usage opportunities, function replacements, and context optimization techniques
- Delivers refactored formulas with improved structure, error handling via DIVIDE and BLANK preservation, and inline documentation
- Covers common patterns like variable caching for expensive calculations, proper iterator function usage, and defensive programming for edge cases
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
More from github/awesome-copilot
git-commit
Execute git commit with conventional commit message analysis, intelligent staging, and message generation. Use when user asks to commit changes, create a git commit, or mentions "/commit". Supports: (1) Auto-detecting type and scope from changes, (2) Generating conventional commit messages from diff, (3) Interactive commit with optional type/scope/description overrides, (4) Intelligent file staging for logical grouping
30.2Kgh-cli
GitHub CLI (gh) comprehensive reference for repositories, issues, pull requests, Actions, projects, releases, gists, codespaces, organizations, extensions, and all GitHub operations from the command line.
21.2Kdocumentation-writer
Diátaxis Documentation Expert. An expert technical writer specializing in creating high-quality software documentation, guided by the principles and structure of the Diátaxis technical documentation authoring framework.
17.4Kprd
Generate high-quality Product Requirements Documents (PRDs) for software systems and AI-powered features. Includes executive summaries, user stories, technical specifications, and risk analysis.
17.4Kexcalidraw-diagram-generator
Generate Excalidraw diagrams from natural language descriptions. Use when asked to "create a diagram", "make a flowchart", "visualize a process", "draw a system architecture", "create a mind map", or "generate an Excalidraw file". Supports flowcharts, relationship diagrams, mind maps, and system architecture diagrams. Outputs .excalidraw JSON files that can be opened directly in Excalidraw.
16.4Krefactor
Surgical code refactoring to improve maintainability without changing behavior. Covers extracting functions, renaming variables, breaking down god functions, improving type safety, eliminating code smells, and applying design patterns. Less drastic than repo-rebuilder; use for gradual improvements.
16.1K