power-bi-daxlisted

Use for DAX measure authoring, validation, YAML unit-test suites, filter context reasoning, Time Intelligence patterns, optimisation, and design patterns. Triggers on: "write a DAX", "create a measure", "CALCULATE", "SUMX", "Time Intelligence", "YTD", "DATEADD", "filter context", "DAX not working", "validate this DAX", "pbi measure", "pbi dax", "pbi testing", "dax test suite", "pbi filter", "filter context", "row context", "iterator", "DAX pattern". Do NOT trigger for report visual layout (→ power-bi-report-design), model schema design (→ power-bi-modeling), or governance naming rules (→ power-bi-governance).
mudassir09/pbi-enterprise-cli · ★ 0 · AI & Automation · score 75

Install: claude install-skill mudassir09/pbi-enterprise-cli

# power-bi-dax DAX authoring, testing, filter context, Time Intelligence, and design patterns. ## Quick Reference ```bash # Measure management pbi measure list pbi measure list --table Sales --json pbi measure add --table Sales --name "Total Revenue" --expression "SUM(Sales[Revenue])" \ --format-string "#,0.00" --description "Net revenue after discounts" pbi measure update --table Sales --name "Total Revenue" --expression "SUM(Sales[Net])" pbi measure delete --table Sales --name "Old Measure" pbi measure audit # complexity scores, missing descriptions pbi measure generate "YTD revenue by product" --table Sales # AI-assisted # DAX query and validation pbi dax validate "TOTALYTD(SUM(Sales[Revenue]), Calendar[Date])" pbi dax query "EVALUATE SUMMARIZE(Sales, Sales[Region], \"Revenue\", SUM(Sales[Revenue]))" pbi dax query --file ./queries/topN.dax --json # Unit test suites pbi dax test --suite ./tests/measures/time_intelligence.yaml pbi dax test --suite ./tests/ --fail-fast pbi dax test --suite ./tests/measures/sales.yaml --json # Filter management pbi filter add --visual "Sales Chart" --type relative-date --period last-30-days pbi filter add --visual "Top Products" --type topN --field Product[Name] --n 10 pbi filter add --page "Overview" --type basic --field Region[Name] --values "EMEA,APAC" pbi filter list pbi filter remove --visual "Sales Chart" --type relative-date ``` --- ## Worked Example 1: Add and test a YTD measure ```bash # Add measure pbi