skills.rest
marcelodfelman
marcelodfelmanCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/marcelodfelman/pbi-skills --skill power-bi-dax
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
marcelodfelmanmarcelodfelman

Power BI Modeling

Build and manage Power BI semantic models with pbi-cli.

Community
Advanced
JNZader-VaultJNZader-Vault

powerbi

Develop Power BI solutions with DAX measures, Power Query transformations, and dashboard designs.

Official
Advanced
GabeujinGabeujin

powerbi-modeling

Guide Power BI semantic model design, DAX measures, and performance tuning.

Community
Advanced
Umbral-BotUmbral-Bot

power-bi

Design Power BI reports with DAX measures, Power Query transformations, and REST API integrations.

Official
Advanced