Master DAX Fundamentals : Power BI & Power Pivot

Zenler Player

Your course is loading. Hang tight.

Course Material

What is DAX
Calculated Columns and Measures
SUM and SUMX
COUNT and COUNTX - Fully understanding Columns and Measures Preview
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 Preview
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