Power BI DAX Optimization Skill for Claude Code: Tune and Clean Up DAX Formulas

Reviews a Power BI DAX formula for speed, readability and maintainability and returns an improved version with explanations.

Installs: 9.2K; on skills.sh
Stars: 40.7K; on GitHub
Updated: Oct 2026; last repo commit

power-bi-dax-optimization makes the agent act as a DAX expert. You paste a formula, and it checks performance, readability, best practices and maintainability, then returns an optimized measure with a commented analysis.

It asks for the formula, the business purpose, the data model relationships and what is slow. Typical fixes in the file are variables for repeated expressions, DIVIDE instead of /, COUNTROWS instead of COUNT and SELECTEDVALUE instead of VALUES. It bundles no scripts.

Good for

Power BI report builders whose DAX measures are slow
Analysts who want messy measures made readable and safer
Teams reviewing measures against DAX best practices

Install power-bi-dax-optimization

Claude Code

1
Download the skill folder from https://github.com/github/awesome-copilot/tree/HEAD/skills/power-bi-dax-optimization.
2
Put it at ~/.claude/skills/power-bi-dax-optimization/ so that SKILL.md sits directly inside.
3
Start a new session; the skill loads when its description matches the task.

Built from the package data we hold. Not yet tested by us.

What's in the skill

When it loads

Comprehensive Power BI DAX formula optimization prompt for improving performance, readability, and maintainability of DAX calculations.

Sections in SKILL.md

Analysis Framework
1. Performance Analysis
2. Readability Assessment
3. Best Practices Compliance
4. Maintainability Review
Optimization Process
Step 1: Current Formula Analysis
Step 2: Optimization Strategy
Step 3: Optimized Formula
Step 4: Explanation and Justification
Common Optimization Patterns
Performance Optimizations:
Readability Improvements:
Error Handling:
Example Output Format
Request Instructions

Key facts

Author: Awesome Copilot Community (power-bi-development plugin.json author)
License: MIT (repo LICENSE, Copyright GitHub, Inc.)
Installs on skills.sh: 9,164 (Nov 2, 2026)
GitHub stars: 40,666 for the github/awesome-copilot repo (Nov 2, 2026)
Last commit: Oct 30, 2026
Files: 1 file: SKILL.md; no scripts
Plugin: Part of the power-bi-development Copilot plugin (4 skills, 4 agents)

What it includes

Looks for expensive operations, repeated expressions and context transitions
Also checks filter complexity and the choice of aggregation functions.
Performance analysis
Checks structure, naming, comments and logical flow
Covers names of measures and variables and the quality of documentation.
Readability assessment
Checks VAR use, column vs measure references, error handling, function choice
Examples named in the file: DIVIDE vs /, and COUNTROWS vs COUNT.
Best practices check
Flags complexity, hard-coded values, dependencies and reuse
Hard-coded values that should be parameters are called out.
Maintainability review
Returns the new measure with a commented analysis block
The comment block lists issues, strategy and expected improvement, then the new measure with variables and defensive handling.
Try: “Please optimize this DAX formula for better performance and readability: Sales Growth = ...”
Optimized formula output
Can also supply DAX templates, test approaches and alternatives
The file lists a DAX pattern library, benchmarking suggestions, alternative approaches, model integration and documentation.
Additional services

From the official docs

Permissions

Low risk

The skill itself is one text file that reviews formulas you paste. The Copilot plugin route adds 4 agents with file-editing and command tools, so inspect them before installing.

What it can do

Read your data
Create and change things
Delete things
Read-only mode

Watch out for

The plugin route adds agents with editing tools
power-bi-development lists 4 agents. The DAX agent file lists tools including editFiles, runCommands, runTasks, runTests and fetch. Install only the skill if you do not want agents. github.com
Collection notice
The awesome-copilot README says its customizations come from third-party developers and should be inspected before installing. github.com

Questions

What does power-bi-dax-optimization do?

It takes a DAX formula and returns a better version. It reviews speed, readability, best practices and maintainability, then explains each change and suggests tests.

Is it from Microsoft?

Not that the files say. The plugin.json lists Awesome Copilot Community as author and the repo license names GitHub, Inc.; neither SKILL.md nor plugin.json names Microsoft. It is a community skill about Microsoft's Power BI, not a Microsoft product.

How do I install it in Claude Code?

Use the install box above. For Claude Code, install the skill folder or use the skills CLI. The Copilot CLI tab installs the larger power-bi-development plugin instead.

What should I give it?

The DAX formula, what it is for, the relevant data model relationships and any performance problem you see. You can also name a goal such as speed or readability.

Does it connect to my Power BI model?

SKILL.md describes a prompt-style review of a formula you paste. It bundles no scripts and defines no connection to Power BI.

What is the power-bi-development plugin?

It is an awesome-copilot plugin for the Copilot CLI that lists 4 skills and 4 agents. The agents are chat modes for data modeling, DAX, performance and visualization.

Is it safe?

The skill is one text file with no scripts, and it reviews formulas you paste. The plugin route is bigger: its 4 agents list tools such as editing files, running commands and running tests, so inspect them first.

Information

updated Nov 2, 2026

Repository: github/awesome-copilot
Folder: skills/power-bi-dax-optimization

github/awesome-copilot skills.sh

Sources

Docs, issue trackers and discussions this page is built from.

Show all 4

github.com · github.com
github.com · github.com
github.com · github.com
github.com · github.com