Power BI11 min read•
DAX Patterns Every Power BI Developer Should Know
Essential DAX patterns and formulas for calculating time intelligence, rankings, and complex business logic.
By Administrator
Master these essential DAX patterns to solve common business analytics challenges efficiently.
Time Intelligence Patterns
Year-to-Date (YTD) YTD Sales = TOTALYTD([Total Sales], 'Date'[Date])
Previous Year Comparison PY Sales = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date])) YoY Growth % = DIVIDE([Total Sales] - [PY Sales], [PY Sales])
Ranking Patterns
Dynamic Ranking Product Rank = RANKX(ALL(Products[ProductName]), [Total Sales], , DESC, DENSE)
Percentage Patterns
Percent of Total % of Total = DIVIDE([Total Sales], CALCULATE([Total Sales], ALL(Products)))
Use variables to optimize performance and avoid repeated calculations.
Frequently Asked Questions
What is the difference between CALCULATE and FILTER in DAX?
CALCULATE modifies filter context and is optimized by the engine. FILTER returns a table and is an iterator. Use CALCULATE for most scenarios.
DAXPower BITime IntelligenceCalculations