dax-query-guidelines
OfficialMaster DAX queries with best-practice patterns.
Data & Analytics#data-analysis#dax#power-bi#time-intelligence#query-best-practices#define-block#summarizecolumns
Authorclientfirsttech
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This guide helps Power BI developers and data professionals write valid, efficient DAX queries by outlining syntax rules, patterns, and best practices.
Core Features & Use Cases
- Query structure guidance: DEFINE blocks, correct use of DEFINE, MEASURE, and ORDER BY to ensure correct evaluation.
- Function usage patterns: SUMMARIZECOLUMNS for measures, SUMMARIZE for distinct values, GROUPBY for table variables, and SELECTCOLUMNS for column projection.
- Time context and TI practices: Establish valid date context for time-intelligence functions and understand best practices for time-based calculations.
- Practical examples: Illustrative DAX queries showing common workflows like filtering, aggregation, and ranking.
Quick Start
Draft a DAX query using this guide to compare yearly sales by product category.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: dax-query-guidelines Download link: https://github.com/clientfirsttech/power-query-lint-vs-code-extension/archive/main.zip#dax-query-guidelines Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.