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:

1. The DAX formula you want optimized
2. Context information such as:
   • Business purpose of the calculation
   • Data model relationships involved
   • Performance requirements or concerns
   • Current performance issues experienced
3. 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."

Weekly Installs

7.3K

Repository

github/awesome-copilot

GitHub Stars

26.9K

First Seen

Feb 25, 2026

Security Audits

Gen Agent Trust HubPassSocketPassSnykPass

Installed on

codex7.3K

gemini-cli7.3K

opencode7.2K

cursor7.2K

github-copilot7.2K

kimi-cli7.2K