Conceptual
Login

About What is DAX in Power BI DAX

Copied

Concepts imported from YouTube curation: https://youtube.com/playlist?list=PLjNd3r1KLjQuVWrPuygE8QwEmCL6rrUrx&si=aU1VFM7aUI7SzYBq

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

What you will learn

What is DAX in Power BI DAX

About Cameron

C

Guide profile coming soon.