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
Install
MinaSaad1/pbi-cli/power-bi-dax · repository language: Python
git clone https://github.com/MinaSaad1/pbi-cli
cp -r pbi-cli/src/pbi_cli/skills/power-bi-dax ~/.claude/skills/power-bi-daxFrequently 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)
Read as markdown · JSON record · Browse the source repository
File tree — 1 file
src/pbi_cli/skills/power-bi-dax/SKILL.md