Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Master DAX fundamentals : Power BI, Power Pivot & SSAS

Video Introducing this tutorial

Master DAX fundamentals : Power BI, Power Pivot & SSAS :
Introduction
How to take this course


DAX (Data Analysis Expression) An Introduction :
What is DAX
Calculated Columns and Measures
SUM and SUMX
Count and CountX
Currency Data Type and the need to ROUND in DAX
DAX DIVIDE expression
When you need a BLANK for the right data type
Related and Related Table
MIN and MAX
Other Expressions
IF Statements
Working with Text in DAX
Section Wrap up
Section 1 Activities


How DAX works :
How DAX works
Table Functions
Ignore Filters
Combining Table Functions
Nested Row Context
Calculate
More on Calculate
Section 2 Wrap up
Section 2 Activity


Time Intelligence Functions :
Introduction to Time Intelligence
Creating a Date Table
Multiple Date Tables
Marking a Date Table
Year to Date Calculations
How Time Intelligence Works
Looking Back in Time
Datesadd
Parallel Periods
Moving Totals
Overall Total
Time Intelligence conclusion
Section 3 Activities


Conclusion :
Course Conclusion
Thank you and bonus
Bonus


Master DAX fundamentals : Power BI, Power Pivot & SSAS
Introduction
How to take this course


DAX (Data Analysis Expression) An Introduction :
What is DAX
Calculated Columns and Measures
SUM and SUMX
Count and CountX
Currency Data Type and the need to ROUND in DAX
DAX DIVIDE expression
When you need a BLANK for the right data type
Related and Related Table
MIN and MAX
Other Expressions
IF Statements
Working with Text in DAX
Section Wrap up
Section 1 Activities


How DAX works :
How DAX works
Table Functions
Ignore Filters
Combining Table Functions
Nested Row Context
Calculate
More on Calculate
Section 2 Wrap up
Section 2 Activity


Time Intelligence Functions :
Introduction to Time Intelligence
Creating a Date Table
Multiple Date Tables
Marking a Date Table
Year to Date Calculations
How Time Intelligence Works
Looking Back in Time
Datesadd
Parallel Periods
Moving Totals
Overall Total
Time Intelligence conclusion
Section 3 Activities


Conclusion :
Course Conclusion
Thank you and bonus
Bonus

You Have Got Gift 25% OFF

Use this Coupon Code “J3JKN396