Course Material
What is DAX
Calculated Columns and Measures
SUM and SUMX
COUNT and COUNTX - Fully understanding Columns and Measures
Working with the data type Currency and ROUND
DAX DIVIDE Expression
Dealing with BLANK()
RELATED and RELATEDTABLE
MIN and MAX
Other Function/Iterator Pairs
TEXT in DAX
DAX IF Statements
DAX Variables
SWITCH in DAX
Section 1 Activity
Section 1 Conclusion
How DAX Works
Table Functions
Ignore Table Functions
Combine Table Functions
Nested Row Context
CALCULATE
More on CALCULATE
DAX and Relationships
Section 2 Wrap up and Activity
Section 2 Activity files
Introduction to Time Intelligence
DAX to create a date table
Multiple DATE columns
Marking a DATE table
Year to date calculations
How Time Intelligence Works
Looking Back in Time
DATESADD
Parallel Periods
Moving Totals
Overall Totals
Time Intelligence Conclusion
Section 3 Activities
Course Conclusion
Course Bonus
Bonus Links
Enroll to Unlock this course.