power-bi-dax-optimization
Comprehensive Power BI DAX formula optimization prompt for improving performance, readability, and maintainability of DAX calculations.
- Installs
- 9.1K
- Last 24h
- —
- Trending rank
- —
- Security
- Warn
Install
Works with every agent the skills CLI supports.
npx skills add https://github.com/github/awesome-copilot --skill power-bi-dax-optimization- 01
Install
Run the command in your project. The CLI asks which agents to install for.
- 02
Describe the task
Ask your agent for something this skill covers. It loads power-bi-dax-optimization automatically when relevant.
- 03
Review the result
The agent follows the SKILL.md steps, scripts and references bundled with the skill.
Security audits
Independent scans of the skill's instructions and bundled files.
SKILL.md
The instructions your agent reads when the skill is triggered.
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 dependency management
- Review reusability potential
Optimization Process
For each DAX formula provided:
Step 1: Current Formula Analysis
Analyze the provided DAX formula and identify:
- Performance bottlenecks
- Readability issues
- Best practice violations
- Potential errors or edge cases
- Maintenance challenges
Step 2: Optimization Strategy
Develop optimization approach:
- Variable usage opportunities
- Function replacements for performance
- Context optimization techniques
- Error handling improvements
- Structure reorganization
Step 3: Optimized Formula
Provide the improved DAX formula with:
- Performance optimizations applied
- Variables for repeated calculations
- Improved readability and structure
- Proper error handling
- Clear commenting and documentation
Step 4: Explanation and Justification
Explain all changes made:
- Performance improvements and expected impact
- Readability enhancements
- Best practice alignments
- Potential trade-offs or considerations
- Testing recommendations
Common Optimization Patterns
Performance Optimizations:
- Variable Usage: Store expensive calculations in variables
- Function Selection: Use COUNTROWS instead of COUNT, SELECTEDVALUE instead of VALUES
- Context Optimization: Minimize context transitions in iterator functions
- Filter Efficiency: Use table expressions and proper filtering techniques
Readability Improvements:
- Descriptive Variables: Use meaningful variable names that explain calculations
- Logical Structure: Organize complex formulas with clear logical flow
- Proper Formatting: Use consistent indentation and line breaks
- Documentation: Add comments explaining business logic
Error Handling:
- DIVIDE Function: Replace division operators with DIVIDE for safety
- BLANK Handling: Proper handling of BLANK values without unnecessary conversion
- Defensive Programming: Validate inputs and handle edge cases
Example Output Format
/*
ORIGINAL FORMULA ANALYSIS:
- Performance Issues: [List identified issues]
- Readability Concerns: [List readability problems]
- Best Practice Violations: [List violations]
OPTIMIZATION STRATEGY:
- [Explain approach and changes]
PERFORMANCE IMPACT:
- Expected improvement: [Quantify if possible]
- Areas of optimization: [List specific improvements]
*/
-- OPTIMIZED FORMULA:
Optimized Measure Name =
VAR DescriptiveVariableName =
CALCULATE(
[Base Measure],
-- Clear filter logic
Table[Column] = "Value"
)
VAR AnotherCalculation =
DIVIDE(
DescriptiveVariableName,
[Denominator Measure]
)
RETURN
IF(
ISBLANK(AnotherCalculation),
BLANK(), -- Preserve BLANK behavior
AnotherCalculation
)
Request Instructions
To use this prompt effectively, provide:
- The DAX formula you want optimized
- Context information such as:
- Business purpose of the calculation
- Data model relationships involved
- Performance requirements or concerns
- Current performance issues experienced
- Specific optimization goals such as:
- Performance improvement
- Readability enhancement
- Best practice compliance
- Error handling improvement
Additional Services
I can also help with:
- DAX Pattern Library: Providing templates for common calculations
- Performance Benchmarking: Suggesting testing approaches
- Alternative Approaches: Multiple optimization strategies for complex scenarios
- Model Integration: How the formula fits with overall model design
- Documentation: Creating comprehensive formula documentation
Usage Example: "Please optimize this DAX formula for better performance and readability:
Sales Growth = ([Total Sales] - CALCULATE([Total Sales], PARALLELPERIOD('Date'[Date], -12, MONTH))) / CALCULATE([Total Sales], PARALLELPERIOD('Date'[Date], -12, MONTH))
This calculates year-over-year sales growth and is used in several report visuals. Current performance is slow when filtering by multiple dimensions."
FAQ
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 power-bi-dax-optimization?
Run npx skills add https://github.com/github/awesome-copilot --skill power-bi-dax-optimization in your project. The skills CLI detects the agents you use and copies the skill into the right folder. For Claude Code you can also place the skill folder at ~/.claude/skills/power-bi-dax-optimization/ (personal) or .claude/skills/power-bi-dax-optimization/ (project).
Which AI agents can use power-bi-dax-optimization?
Any agent that supports the open Agent Skills format (a folder with a SKILL.md file), including Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, Windsurf, Cline, OpenCode and more.
Is power-bi-dax-optimization safe to install?
Security partners have reviewed it: Gen Agent Trust Hub passed; Socket passed; Snyk passed; Runlayer flagged items to review; ZeroLeaks passed. As with any skill, read the SKILL.md and bundled scripts before installing.
Who maintains power-bi-dax-optimization?
It is published by github in github/awesome-copilot, and it is an official skill from the maker of the technology it covers. It has 9,147 recorded installs.
More from github/awesome-copilot
git-commit
github/awesome-copilot
Use this skill when the user wants to make a Git commit or split changes into more than one commit. Also use it when the user types "/commit" or asks for a conventional commit. The skill examines the diff, stages the related files, writes a Conventional Commits message, and runs git commit. Do not use it when the user wants only a commit message and no commit. Do not use it to push, open a pull request, rebase, or change the commit history.
excalidraw-diagram-generator
github/awesome-copilot
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.
multi-stage-dockerfile
github/awesome-copilot
Create optimized multi-stage Dockerfiles for any language or framework
documentation-writer
github/awesome-copilot
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.
prd
github/awesome-copilot
Generate high-quality Product Requirements Documents (PRDs) for software systems and AI-powered features. Includes executive summaries, user stories, technical specifications, and risk analysis.
refactor
github/awesome-copilot
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.
Popular ai & agents skills
google-agents-cli-publish
google/agents-cli
This skill should be used when the user wants to "publish an agent", "publish my ADK agent", "register an agent with Gemini", "publish to Gemini" (formerly Gemini Enterprise), or needs guidance on the agents-cli publish gemini command. Also use when the user wants to "manage agents in Agent Registry", "list/update/delete registered agents", or "register an MCP server". Covers ADK vs A2A registration modes, programmatic and interactive usage, flag reference, auto-detection from deployment metadata, Agent Registry fleet management, and troubleshooting. Part of the agents-cli skills suite. Do NOT use for deployment (use google-agents-cli-deploy).
google-agents-cli-eval
google/agents-cli
This skill should be used when the user wants to "run an evaluation", "evaluate my agent", "evaluate my ADK agent", "write an eval dataset", "analyze eval failures", "compare eval results", "optimize agent", or needs guidance on the Gemini platform eval methodology and the Quality Flywheel. Covers eval metrics, dataset schema, LLM-as-judge scoring, and common failure causes. Applies to any agents-cli project, whatever framework the agent is written in. Do NOT use for agent API code patterns (ADK: use google-agents-cli-adk-code), deployment (use google-agents-cli-deploy), or project scaffolding (use google-agents-cli-scaffold).
skill-creator
anthropics/skills
Create new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy.
codex-pet
prime-skills/runcomfy-agent-skills
Codex Pet generator on RunComfy. Build a Codex-compatible Codex Pet spritesheet.webp + pet.json from a single reference image, drop it into ${CODEXHOME:-$HOME/.codex}/pets/ / and Codex picks it up as a custom Codex Pet next to the 8 built-ins. This skill produces the exact Codex Pet atlas Codex expects (1536x1872 PNG/WebP, 8 cols x 9 rows, 192x208 cells, 9 animation states — idle, running-right, running-left, waving, jumping, failed, waiting, running, review). Calls OpenAI GPT Image 2 edit ONCE via the local RunComfy CLI as runcomfy run openai/gpt-image-2/edit to produce a canonical Codex Pet pose, then assembles all 9 animation rows programmatically with ImageMagick micro-transforms — no Codex Pro, no $imagegen, no OPENAIAPIKEY required, only RUNCOMFYTOKEN. Triggers on "codex pet", "create codex pet", "make codex pet", "hatch codex pet", "/hatch image", "desktop pet codex", "codex pets", "spritesheet.webp", or any explicit ask to build a custom pet for OpenAI Codex.
full-output-enforcement
leonxlnx/taste-skill
Overrides default LLM truncation behavior. Enforces complete code generation, bans placeholder patterns, and handles token-limit splits cleanly. Apply to any task requiring exhaustive, unabridged output.
executing-plans
obra/superpowers
Use when executing an implementation plan in the current session as the implementer yourself — your human partner chose inline execution, or no subagent tool is available