Power BI DAX
Power BI DAX lets you run, test, and refine DAX expressions directly against your semantic models via pbi-cli. Build measures, explore model structure, and validate queries with built-in performance guidance for aggregations, time intelligence, and filtering.
Power BI DAX executes and validates DAX queries against your Power BI semantic models using pbi-cli.
AI-generated summary based on this skill's SKILL.md
Decision gist · record as of 2026-07-27
Power BI DAX executes and validates DAX queries against your Power BI semantic models using pbi-cli. Power BI DAX lets you run, test, and refine DAX expressions directly against your semantic models via pbi-cli. Build measures, explore model structure, and validate queries with built-in performance guidance for aggregations, time intelligence, and filtering.
Use it when
- Yes.
- Power BI DAX includes built-in support for time intelligence functions and year-over-year analysis.
Verify before relying
Read SKILL.md below before installing (1 file). Open directory: indexed for reading, not audited.
Install
MinaSaad1/pbi-cli/power-bi-dax · repository language: Python
Open directory. Skills are indexed for reading, not audited. Review a skill's body before installing it.
Frequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
How do I write DAX queries in Power BI using this skill?
Power BI DAX enables you to write and execute DAX expressions directly against your semantic models through pbi-cli. You can compose single-line or multi-line DAX queries using VAR RETURN syntax, pipe them via stdin, and validate them before running. The skill handles argument passing and syntax parsing, letting you test measures, aggregations, and filtering logic in real time against live model data.
Can Power BI DAX help me create and optimize measures?
Yes. Power BI DAX supports creating and optimizing DAX measures for your calculations. You can build measures using CALCULATE, SUMMARIZECOLUMNS, and other aggregation functions, then execute them against your semantic model to verify correctness and performance. The skill provides guidance on measure optimization and helps you debug multi-line syntax errors in your formulas.
How do I implement time intelligence and year-over-year analysis?
Power BI DAX includes built-in support for time intelligence functions and year-over-year analysis. You can construct YTD (year-to-date), rolling period, and comparative calculations using DAX time functions, then execute them to validate results. The skill helps you structure these expressions and test them against your model's date dimensions.
What should I do if I get a VAR RETURN syntax error in DAX?
Power BI DAX helps you debug multi-line DAX syntax and CLI argument passing issues, including VAR RETURN errors. The skill validates your expression structure, checks for common syntax mistakes, and provides guidance on proper variable declaration and return statement formatting. You can test corrected expressions immediately against your semantic model.
How can I explore and aggregate data from my Power BI model?
Power BI DAX lets you explore and aggregate data using SUMMARIZECOLUMNS, EVALUATE, and TOPN queries. You can structure aggregation and grouping logic, execute it against your semantic model to retrieve results, and refine your expressions based on the output. The skill supports model structure exploration and data validation workflows.
Is Power BI DAX open source and what license does it use?
Power BI DAX is released under the MIT license, making it free and open source. You can use, modify, and distribute it according to MIT terms.
SKILL.md
Rendered from the published skill. Quoted content, verbatim.
Power BI DAX Skill
Execute and validate DAX queries against connected Power BI models.
Prerequisites
pipx install pbi-cli-tool
pbi-cli skills install
pbi connect
Executing Queries
```bash
Inline query
pbi dax execute "EVALUATE TOPN(10, Sales)"
From file
pbi dax execute --file query.dax
From stdin (piping)
cat query.dax | pbi dax execute - echo "EVALUATE Sales" | pbi dax execute -
With options
pbi dax execute "EVALUATE Sales" --max-rows 100 pbi dax execute "EVALUATE Sales" --timeout 300 # Custom timeout (seconds)
JSON output for
(truncated - see the full file via the links below)
File tree — 1 file
src/pbi_cli/skills/power-bi-dax/SKILL.md
Let your AI agent find skills like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 56,283 agent skills by what they can do, searchable in plain language.
wish › “Execute and validate DAX queries against Power BI semantic models”
Give your agent the search over MCP, or paste the wish link into any chat. No install? Search from any chat →
Related skills
Power Bi Build creates IPPF-branded Power BI projects by writing DAX measures into your semantic model, applying the IPPF Visual Identity 2025 theme, and generating page recipe templates for indicator dashboards, equity disaggregation, and methodology cards. It works with the pbi CLI to automate model operations while staging report pages for manual refinement in Power BI Desktop.
Power BI Visuals enables you to create, bind, and manage 32+ visual types on PBIR report pages directly via pbi-cli, without needing Power BI Desktop. Supported visuals include bar charts, line charts, scatter plots, matrices, KPIs, gauges, and more, each configurable with custom positioning, sizing, and data binding. Bulk operations let you apply changes across multiple visuals at once by type or name pattern.
Control which data appears on your Power BI report pages and visuals by adding categorical, TopN, and relative date filters through pbi-cli commands. Filters are stored directly in your report's configuration without requiring Power BI Desktop, and you can batch changes to minimize reloads.
This skill guides you through complete Power BI projects using the PBIP format—a git-friendly, text-based structure for version control. Work with TMDL semantic models, Power Query expressions, DAX measures, and star schema relationships, then publish to Power BI Service with scheduled refresh and gateway configuration.
Expert guidance for connecting to Power BI Desktop's local tabular model using the Tabular Object Model and ADOMD.NET in PowerShell. Covers enumeration, DAX queries, model modification, and Desktop Bridge operations for reloading and verification.
Manage report-wide themes and per-visual conditional formatting without needing Power BI Desktop. Apply JSON theme files to set colors, fonts, and visual defaults across your entire report, preview changes before committing, and apply data-driven formatting rules to individual visuals using gradient, rule-based, or measure-driven approaches.
More skills Power BI Pages (MIT)