Power BI DAX

Write, execute, and optimize DAX queries for Power BI semantic models.

Updated Apr 17, 2026

Search Tags:#analytics #queries #dax #power bi #measures #semantic models

Ready to run

npx skills add https://github.com/marcelodfelman/pbi-skills --skill power-bi-dax

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: Power BI DAX
Source: https://github.com/marcelodfelman/pbi-skills/tree/main/power-bi-dax
Command: npx skills add https://github.com/marcelodfelman/pbi-skills --skill power-bi-dax

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps users write, validate, execute, and optimize DAX calculations and queries against Power BI semantic models without manually navigating complex data analysis workflows.

Core Features & Use Cases

DAX Query Execution: Run EVALUATE queries, inspect model data, validate expressions, and retrieve aggregated results from connected Power BI models.
Measure Development: Create and optimize DAX measures for aggregations, time intelligence, filtering, and business calculations using pbi-cli.
Use Case: Analyze a sales semantic model by creating revenue, year-over-year growth, and ranking measures while validating query results directly against the Power BI engine.

Quick Start

Use the Power BI DAX skill to analyze my connected semantic model and create a measure for total sales.

Frequently Asked Questions about Power BI DAX

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I write and validate DAX queries against a Power BI semantic model?▼

You can write and validate DAX queries by running EVALUATE expressions and retrieving aggregated results directly from connected Power BI semantic models using pbi-cli integration. This handles query validation, measure creation, and live model connections without manual workflows.

Can I create time intelligence measures for year-over-year growth in Power BI?▼

Yes, you can create and optimize DAX measures for time intelligence, filtering, and aggregations. The Skill supports developing business calculations like year-over-year growth and revenue ranking while validating results against the Power BI engine.

Do I need pbi-cli to execute DAX measures on live Power BI connections?▼

Yes, pbi-cli integration is required to execute DAX expressions, manage query validation, handle measure creation, and work with live Power BI semantic model connections for data analysis scenarios.

What's the best way to optimize DAX calculations for Power BI aggregations?▼

The best way to optimize DAX calculations is by writing, validating, and executing expressions against Power BI semantic models to inspect model data and retrieve aggregated results, ensuring measures are validated directly within the Power BI engine.

Does this approach work for exploring semantic model data before building reports?▼

Yes, this approach supports semantic model exploration by allowing you to run EVALUATE queries, inspect model data, validate expressions, and retrieve aggregated results from connected Power BI models prior to report development.