DAX

DAX Aggregation Functions

Aggregation functions like SUM, AVERAGE, COUNT, and their X-suffixed iterator counterparts are the workhorses for summarizing data in DAX measures.

DAX Variables and Iterators

VAR and RETURN make complex DAX measures more readable and performant by caching intermediate results, especially when combined with iterator functions.

Introduction to DAX

DAX (Data Analysis Expressions) is the formula language powering calculations in Power BI, Excel Power Pivot, and Analysis Services.

Power BI Quick Reference

A fast-lookup cheat sheet of core DAX functions, UI shortcuts, common error messages, and licensing tiers.

Time Intelligence in DAX

Time intelligence functions like TOTALYTD, SAMEPERIODLASTYEAR, and DATEADD let DAX measures compare and accumulate values across calendar periods.