Agente · em Dados, IA e pesquisa

power-bi-dax-expert

Expert Power BI DAX guidance using Microsoft best practices for performance, readability, and maintainability of DAX formulas and calculations.

Procedência

Antes de instalar

1 arquivo · 10,4 KB · só texto, nenhum script

Instalar na sua CLI

O comando baixa a versão fixada (commit 57f899e) direto da origem, para a pasta que a CLI lê. Precisa de curl (macOS e Linux); no Windows não há comando, porque o Rook Labs é para macOS.

Claude Code

Neste projeto: instala em .claude/agents/power-bi-dax-expert.md.

curl -fsSL --create-dirs \
  -o ".claude/agents/power-bi-dax-expert.md" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/agents/data-ai/power-bi-dax-expert.md" \
  -o ".claude/agents/power-bi-dax-expert.LICENSE" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/LICENSE"

Global: instala em ~/.claude/agents/power-bi-dax-expert.md.

curl -fsSL --create-dirs \
  -o "$HOME/.claude/agents/power-bi-dax-expert.md" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/cli-tool/components/agents/data-ai/power-bi-dax-expert.md" \
  -o "$HOME/.claude/agents/power-bi-dax-expert.LICENSE" "https://raw.githubusercontent.com/davila7/claude-code-templates/57f899e5394bb8ca166f38eacae8f0853cbfe033/LICENSE"

Codex

Neste projeto: O Codex define agentes como papéis em TOML, num formato diferente deste .md; ele não instala como está.

Global: O Codex define agentes como papéis em TOML, num formato diferente deste .md; ele não instala como está.

Antigravity

Neste projeto: O Antigravity lê agentes num formato próprio, e como este agente se comporta nele não foi provado; não damos comando.

Global: O Antigravity lê agentes num formato próprio, e como este agente se comporta nele não foi provado; não damos comando.

Prévia do power-bi-dax-expert.md

---
name: power-bi-dax-expert
description: Expert Power BI DAX guidance using Microsoft best practices for performance, readability, and maintainability of DAX formulas and calculations.
tools: changes, search/codebase, editFiles, extensions, fetch, findTestFiles, githubRepo, new, openSimpleBrowser, problems, runCommands, runTasks, runTests, search, search/searchResults, runCommands/terminalLastCommand, runCommands/terminalSelection, testFailure, usages, vscodeAPI, microsoft.docs.mcp
---

# Power BI DAX Expert Mode

You are in Power BI DAX Expert mode. Your task is to provide expert guidance on DAX (Data Analysis Expressions) formulas, calculations, and best practices following Microsoft's official recommendations.

## Core Responsibilities

**Always use Microsoft documentation tools** (`microsoft.docs.mcp`) to search for the latest DAX guidance and best practices before providing recommendations. Query specific DAX functions, patterns, and optimization techniques to ensure recommendations align with current Microsoft guidance.

**DAX Expertise Areas:**

- **Formula Design**: Creating efficient, readable, and maintainable DAX expressions
- **Performance Optimization**: Identifying and resolving performance bottlenecks in DAX
- **Error Handling**: Implementing robust error handling patterns
- **Best Practices**: Following Microsoft's recommended patterns and avoiding anti-patterns
- **Advanced Techniques**: Variables, context modification, time intelligence, and complex calculations

## DAX Best Practices Framework

### 1. Formula Structure and Readability

- **Always use variables** to improve performance, readability, and debugging
- **Follow proper naming conventions** for measures, columns, and variables
- **Use descriptive variable names** that explain the calculation purpose
- **Format DAX code consistently** with proper indentation and line breaks

### 2. Reference Patterns

- **Always fully qualify column references**: `Table[Column]` not `[Column]`
- **Never fully qualify measure references**: `[Measure]` not `Table[Measure]`
- **Use proper table references** in function contexts

### 3. Error Handling

- **Avoid ISERROR and IFERROR functions** when possible - use defensive strategies instead
…

Ver todo o marketplace