Does it follow official Microsoft Power BI best practices?

Yes, the optimization framework is built around industry-standard best practices, including proper measure referencing, variable scoping, and efficient function selection.

How does it improve DAX performance?

The skill identifies expensive calculation patterns, optimizes filter contexts, and suggests the use of variables to prevent redundant processing within the formula.

Is this skill useful for large-scale data models?

Absolutely. It is specifically designed to handle the complexity of enterprise-level data models where formula efficiency is critical for report responsiveness.

What is the Power BI DAX Optimizer skill?

It is a specialized capability for Claude Code that analyzes, refactors, and improves DAX formulas to ensure they run faster and are easier to maintain.

Can it fix errors in my DAX code?

Yes, it evaluates error handling approaches and suggests defensive programming patterns, such as using the DIVIDE function to prevent division-by-zero errors.

Power BI DAX Optimizer

Name: Power BI DAX Optimizer
Author: rodolfolermacontreras

byrodolfolermacontreras

•

분석 및 모니터링

Optimizes Power BI DAX formulas to improve performance, readability, and maintainability using industry-standard best practices.

The Power BI DAX Optimizer skill transforms Claude into a specialized business intelligence consultant focused on refining and tuning DAX expressions. By analyzing formula structure, identifying expensive operations, and detecting inefficient context transitions, it provides actionable refactoring strategies that reduce report latency and improve code clarity. Whether you are dealing with slow-loading visuals or complex nested calculations, this skill implements patterns like variable usage, proper filtering techniques, and safe error handling to ensure your Power BI models are scalable and professional.

주요 기능

01Automated performance bottleneck identification in complex DAX expressions

02Optimization of context transitions within iterator functions

03Detailed justification reports for every suggested optimization

04Comprehensive refactoring for improved readability and naming conventions

05Standardization of best practices like VAR usage and DIVIDE function safety

061 GitHub stars

사용 사례

01Refactoring legacy DAX measures to improve report load times and visual performance

02Converting complex business logic into clean, variable-based DAX patterns

03Auditing DAX formulas for best practice compliance during code reviews

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rodolfolermacontreras/microsoft-ai-learning power-bi-dax-optimization

For use in Claude.ai and ChatGPT

주요 기능

01Automated performance bottleneck identification in complex DAX expressions

02Optimization of context transitions within iterator functions

03Detailed justification reports for every suggested optimization

04Comprehensive refactoring for improved readability and naming conventions

05Standardization of best practices like VAR usage and DIVIDE function safety

061 GitHub stars

사용 사례

01Refactoring legacy DAX measures to improve report load times and visual performance

02Converting complex business logic into clean, variable-based DAX patterns

03Auditing DAX formulas for best practice compliance during code reviews

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rodolfolermacontreras/microsoft-ai-learning power-bi-dax-optimization

For use in Claude.ai and ChatGPT