Dive into a comprehensive 2.5-hour video tutorial on the fundamentals of DAX in Power BI and Power Pivot. Learn about columnar databases, DAX calculated columns, measures, row context, filter context, context transition, overwrite operations, DAX X iterator functions, and the CALCULATE function. Explore topics such as star schema data models, implicit measures, SUMX function, DIVIDE function, ALL and ALLSELECTED functions, variables in DAX, boolean filters, logical tests, and context transition errors. Discover techniques for optimizing formula calculation speed, creating date tables, and extracting data from Power Pivot data models. Access downloadable files, including 50 pages of PDF notes, to enhance your learning experience. Taught by an Excel MVP and Highline College Professor, this class covers essential DAX concepts for data analysis and visualization in Microsoft 365 Excel and Power BI.