Official agent skill

Power Bi Dax Optimization

by github in github/awesome-copilot

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

OfficialMITAuto-check passedData & Analytics

Install Power Bi Dax Optimization

skills CLI
$ npx skills add github/awesome-copilot --skill power-bi-dax-optimization -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install github/awesome-copilot power-bi-dax-optimization --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/github/awesome-copilot.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/power-bi-dax-optimization .claude/skills/power-bi-dax-optimization && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
power-bi-dax-optimization
GitHub stars
40k
Used in
1 other repo
Token cost
~1.4k tokens
SKILL.md length
415 words
Files
1
Skills in repo
417
Repo updated
First seen
Licence
MIT

At a glance

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

  • Works in 8 steps: Performance Analysis → Readability Assessment → Best Practices Compliance → …
  • Tasks that involve Plain language and style rules
  • SKILL.md covers Analysis Framework, Optimization Process, Common Optimization Patterns and Example Output Format, plus 2 more sections
  • Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md

What it does

Power Bi Dax Optimization is an agent skill from github/awesome-copilot, published by the product's own GitHub organization. Comprehensive Power BI DAX formula optimization prompt for improving performance, readability, and maintainability of DAX calculations.

Its SKILL.md is about 1.4k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Data & Analytics, covering Plain language and style rules. It works with Power BI. The repository describes itself as: Community-contributed instructions, agents, skills, and configurations to help you make the most of GitHub Copilot. The licence is MIT.

When your agent uses it

  • Tasks that involve Plain language and style rules

Example prompts

  • “/power-bi-dax-optimization”

Workflow steps

8 steps, taken from the step headings in SKILL.md.

  1. Performance Analysis
  2. Readability Assessment
  3. Best Practices Compliance
  4. Maintainability Review
  5. Current Formula Analysis
  6. Optimization Strategy
  7. Optimized Formula
  8. Explanation and Justification

What it can do on your machine

Read from SKILL.md and the folder at commit 727ff2e. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    No scripts in the folder and no shell commands in SKILL.md (its code samples are dax).

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Power Bi Dax Optimization loads about 1.4k tokens when it runs. Until then it costs about 40 tokens; SKILL.md has 415 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~40
When it runs · the whole SKILL.md, loaded when a task matches
~1.4k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from github/awesome-copilot at commit 727ff2e, republished under its MIT licence (© github). 415 words, ~1,390 tokens.

Download SKILL.mdSave it as .claude/skills/power-bi-dax-optimization/SKILL.md (or your agent's skills folder).
name
power-bi-dax-optimization
description
Comprehensive Power BI DAX formula optimization prompt for improving performance, readability, and maintainability of DAX calculations.

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
Show full SKILL.md (161 more words)Show less
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

dax
/* 
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:

dax
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."

© github, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in skills/power-bi-dax-optimization of github/awesome-copilot.

Open the folder on GitHubat commit 727ff2e

Used in 1 other repository

We found 1 copy of this SKILL.md (exact, near-identical or edited) in other folders, from 1 other GitHub owner. This page covers the copy in github/awesome-copilot, which our catalogue first saw on October 7, 2026.

Compare with similar skills

Power Bi Dax Optimization next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Power Bi Dax Optimization compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Power Bi Dax Optimization this skillgithub/awesome-copilot40k1 repos~1.4kAutomated safety check: PassMIT
Ieee Figure TableCloudWave818/ieee-skills353—~1kAutomated safety check: PassMIT
Power Bi AI ReadinessDKH-DK/Self-Service-Power-BI-Fabric113—~2kAutomated safety check: PassNone
Pbi Report Builderlukasreese/powerbi-claude-skills128—~7.5kAutomated safety check: PassNone
Pbi Docxperiun/skills-xperiun-free117—~3kAutomated safety check: PassMIT
Pbip Dependency Analyzerlukasreese/powerbi-claude-skills128—~3.2kAutomated safety check: PassNone

Similar skills

  • Ieee Figure Table

    CloudWave818/ieee-skills

    Audit, redesign, generate, and improve IEEE manuscript figures, tables, captions, result presentation, plotting scripts, visual polish, hybrid Python/R plus vector-editor workflows…

    353 GitHub stars~1k tokensUpdated 1 mo ago
    Data & AnalyticsAuto-check passed
  • Power Bi AI Readiness

    DKH-DK/Self-Service-Power-BI-Fabric

    Score and prepare Power BI semantic models for AI (Fabric Data Agent / Copilot).

    113 GitHub stars~2k tokensUpdated 3 mo ago
    Data & AnalyticsAuto-check passed
  • Pbi Report Builder

    lukasreese/powerbi-claude-skills

    [power-bi] Power BI PBIR Report Builder with IBCS Visuals. An agent skill from lukasreese/powerbi-claude-skills.

    128 GitHub stars~7.5k tokensUpdated 5 mo ago
    Data & AnalyticsAuto-check passed
  • Pbi Doc

    xperiun/skills-xperiun-free

    Documenta projeto Power BI (PBIP) inteiro em markdown estruturado + HTML navegável (mini-site de doc).

    117 GitHub stars~3k tokensUpdated 21 days ago
    Data & AnalyticsAuto-check passed
  • Pbip Dependency Analyzer

    lukasreese/powerbi-claude-skills

    Power BI PBIP Dependency Analyzer. An agent skill from lukasreese/powerbi-claude-skills.

    128 GitHub stars~3.2k tokensUpdated 5 mo ago
    Data & AnalyticsAuto-check passed
  • Audit Tenant Settings

    data-goblin/power-bi-agentic-development

    Automatically invoke this skill whenever the user asks about Fabric tenant settings or Power BI tenant settings or auditing tenant settings.

    1k GitHub stars~4.7k tokensUpdated 2 days ago
    Data & AnalyticsAuto-check passed

More from github/awesome-copilot

All 417 skills in this repo
  • Acquire Codebase Knowledge

    github/awesome-copilot

    Official

    Maps an unfamiliar codebase into seven evidence-backed documents in docs/codebase/, using a scan script and templates, for onboarding or architecture write-ups.

    40k GitHub starsUsed in 1 repo~2.3k tokens
    Auto-check passed
  • Azure Architecture Autopilot

    github/awesome-copilot

    Official

    Designs Azure infrastructure from a natural-language description, or diagrams an existing resource group, then refines the design through conversation and deploys it with Bicep.

    40k GitHub starsUsed in 1 repo~1.9k tokens
    Auto-check passed
  • Draw.io Diagram Generator

    github/awesome-copilot

    Official

    Generates, edits and validates draw.io files with correct mxGraph XML, covering flowcharts, architecture, sequence, ER and UML class diagrams.

    40k GitHub starsUsed in 1 repo~4.9k tokens
    Auto-check passed
  • Credit Risk Data Cleaning

    github/awesome-copilot

    Official

    Cleans raw credit data and screens variables before loan modeling, dropping unstable, noisy or redundant features and writing an Excel report of every step.

    40k GitHub starsUsed in 1 repo~1.5k tokens
    Auto-check passed
  • Daily Focus Board

    github/awesome-copilot

    Official

    Builds a warm, browser-based daily focus board the user updates by talking to their agent, with Eisenhower priorities, a brain-dump box and kind not-today carryover.

    40k GitHub stars~3k tokensUpdated today
    Auto-check passed
  • Python Pypi Package Builder

    github/awesome-copilot

    Official

    End-to-end skill for building, testing, linting, versioning, and publishing a production-grade Python library to PyPI.

    40k GitHub starsUsed in 1 repo~4.6k tokens
    Auto-check passed

Works with

Questions about Power Bi Dax Optimization

What does Power Bi Dax Optimization do?

Comprehensive Power BI DAX formula optimization prompt for improving performance, readability, and maintainability of DAX calculations. Power Bi Dax Optimization is an agent skill from github/awesome-copilot, published by the product's own GitHub organization. Comprehensive Power BI DAX formula optimization prompt for improving performance, readability, and maintainability of DAX calculations.

When should I use Power Bi Dax Optimization?

Power Bi Dax Optimization fits situations like: tasks that involve Plain language and style rules.

How do I install Power Bi Dax Optimization in Claude Code?

Run `npx skills add github/awesome-copilot --skill power-bi-dax-optimization -a claude-code`. Or copy the skill folder (skills/power-bi-dax-optimization in github/awesome-copilot) into .claude/skills/power-bi-dax-optimization in your project. Claude Code loads it when a task matches its description.

How do I install Power Bi Dax Optimization in Codex?

Run `npx skills add github/awesome-copilot --skill power-bi-dax-optimization -a codex`. Or copy the skill folder (skills/power-bi-dax-optimization in github/awesome-copilot) into .agents/skills/power-bi-dax-optimization in your project. Codex loads it when a task matches its description.

Can I use Power Bi Dax Optimization in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add github/awesome-copilot --skill power-bi-dax-optimization -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/power-bi-dax-optimization, .gemini/skills/power-bi-dax-optimization, .github/skills/power-bi-dax-optimization and .opencode/skills/power-bi-dax-optimization in your project.

What does Power Bi Dax Optimization need to run?

SKILL.md names no scripts, command-line tools or credentials: Power Bi Dax Optimization is instructions for the agent only.

Does Power Bi Dax Optimization access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Power Bi Dax Optimization safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Power Bi Dax Optimization use?

Power Bi Dax Optimization is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Power Bi Dax Optimization use?

About 1.4k tokens (SKILL.md is roughly 5.6k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Power Bi Dax Optimization?

Skills that share tags, products or a category with Power Bi Dax Optimization: Ieee Figure Table (CloudWave818/ieee-skills, 353 stars), Power Bi AI Readiness (DKH-DK/Self-Service-Power-BI-Fabric, 113 stars), Pbi Report Builder (lukasreese/powerbi-claude-skills, 128 stars) and Pbi Doc (xperiun/skills-xperiun-free, 117 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Power Bi Dax Optimization?

github (a GitHub organization, an official publisher) maintains it in github/awesome-copilot, which has 39,748 GitHub stars. The repository holds 417 skills in this directory. The repository was last updated on October 7, 2026.

Source: github/awesome-copilot on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.