Estimated Time to Complete
Only available after login
What You'll Learn
Concepts:
CONCATENATEX for Resolving Tied Rows into a Single String
Marking a Date Table to Enable Implicit REMOVEFILTERS in Time Intelligence Calculations
CALCULATE: Context Transition and Filter Modification
DAX Variables in Power BI
Global Running Totals Without Resetting at Partition Boundaries
DAX Measures vs Calculated Columns
Counting Working Days Between Dates Using a Boolean-Flagged Date Table
Row Context: Iterators and the Current-Row Evaluation Environment
USERELATIONSHIP: Dynamic Relationship Activation for Ambiguous Filter Paths
Filter Context Transitions in DAX
Dynamic Temporal Alignment Filtering vs Static Calendar Comparisons in DAX
Filter Context in DAX
DAX Variables: Readability and Table Storage Optimization
Implicit ALL Filter-Clearing on Date Columns in DAX Time Intelligence Functions
DAX Context Transition: Row Context to Filter Context via CALCULATE
SUMX Iteration to Compute Totals by Summing Visible Values
Sorting Fiscal Month Names via a Synthetic Sort-Key Column
CONCATENATEX String Aggregation in DAX
Date Table Creation Using CALENDARAUTO