Estimated Time to Complete
Only available after login
What You'll Learn
Concepts:
Set Union and Intersection
Forecast Accuracy Using AVERAGEX in DAX
DISTINCTCOUNT vs. DISTINCTCOUNTNOBLANK in DAX
DAX Variables: Storing Scalar and Table Results for Calculations
DAX RELATED Function Inside a SUMX Iterator
DAX Variables in Power BI
CONTAINSSTRING and CONTAINSSTRINGEXACT: Boolean Pattern Matching in DAX
Offsetting Dates by Whole Calendar Periods
Year-over-Year Comparisons with DAX SAMEPERIODLASTYEAR
COALESCE in DAX to Replace Blank Values
Closed vs Half-Open Interval Endpoints
Row Context vs. Filter Context and Context Transition in DAX
Moving Averages with DAX DATESINPERIOD and DATEADD
MAX, MAXX, and MAXA in DAX: Standard, Iterator, and Boolean-Aware Aggregation
DAX Set Operations: UNION, INTERSECT, and EXCEPT
Create Calculated Table with Custom Values in DAX
DATESBETWEEN vs. DATESINPERIOD: Absolute vs. Relative Date Boundaries in DAX
Computing a Moving Average
Cardinality (Databases)
MTD, QTD, and YTD Time Intelligence Measures in DAX
CLOSINGBALANCE and OPENINGBALANCE: Semi-Additive Measures in DAX
Validating AI-Generated DAX Measures Requires Human Schema Knowledge
Summation Notation
Flexible Period Offsets with DAX DATEADD
DAX Query View in Power BI Desktop
COUNTROWS with VALUES: A Faster Alternative to DISTINCTCOUNT in DAX
Junk Dimensions for Multi-Column Slicer Filtering
Cumulative Partial Sums and Prefix Sum Computation
Three-Month Rolling Average in DAX
Defaulting to the Latest Fact Date Using ALL() in DAX
FILTER vs. CALCULATETABLE: Context Transition and Multi-Condition Row Filtering in DAX
Percentage Change Between Two Values
DAX DISTINCT: Removing Duplicates from Columns and Table Expressions
DAX SUMMARIZE Wrapped in SUMX for Filter-Preserving Virtual Tables
DAX USERELATIONSHIP: Activating Inactive Relationships for Role-Playing Dimensions
SQL to DAX: Mapping SELECT, WHERE, and HAVING to EVALUATE, FILTER, and SUMMARIZE
SELECTEDVALUE with Disconnected Dimensions for Partial Cumulative Aggregation in DAX
Set Difference and Symmetric Difference Operations
DAX Variables: Readability, Performance, and Context Transition
SUM vs. SUMX: When Row-by-Row Iteration Is Required in DAX
PREVIOUSMONTH, PREVIOUSQUARTER, and PREVIOUSYEAR Time Intelligence in DAX