Master DAX fundamentals : Power BI, Power Pivot & SSAS
The Fundamentals of Data Analysis and Modelling with DAX for Power BI, Power Pivot and Analysis Services
4.01 (882 reviews)
4,171
students
3 hours
content
May 2020
last update
$44.99
regular price
What you will learn
Explain and use Calculated Columns and Measures
Explain and use aggregation functions and expressions in DAX such as SUM and COUNT
Explain and use table functions such as Filter and RelatedTable
Explain and use iteration pairs such as SUMX and COUNTX
Set up Variables
Work with IF statements and DAX SWITCH function
Describe the fundamentals of how DAX works
Explain Row context and nested Row context
Explain Filter context
Use the ALL function to remove filters
Use the Calculate function to modify and replace basic filters
Explain and demonstrate how Relationships and DAX work together
Discuss the need for a DATE table
Use DAX to create a DATE table using CalendarAuto and other DAX functions
Use and explain Time Intelligence Functions such as TOTALTYD, SAMEPERIODLASTYEAR and more
Calculate Moving totals and Rolling Totals
Carry out Basic to Intermediate level DAX analysis
Related Topics
1227150
udemy ID
5/23/2017
course created date
11/20/2019
course indexed date
Bot
course submited by