Data Analysis Expressions (DAX) is a programming language that is used throughout Microsoft Power BI for creating calculated columns, measures, and custom tables. It is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values.
Dr. Sameer Rohadia, a Microsoft Certified Power BI Professional & Microsoft Certified Trainer, has trained 9000+ Industry professionals, University Professors and students in the area of MS Power BI and MS Excel. He has a reputation for delivering excellent, logically structured courses that are easy to follow and get the point across without wasting learners’ time.
In this 15-hour virtual & hands-on course, you will learn how to create relationships, measures, calculated columns, use DAX and all the other skills you need to build a data model that ensures your reports are top-notch!
Enjoy clear and concise step by step lessons from a 5-star rated BI Specialist & Certified IT Trainer
Use DAX and learn what you can achieve with DAX if utilized well
Structure and format DAX formula
Have a comprehensive understanding of creating data models and developing DAX formulas in Microsoft Power BI
Create calculated Columns and Measures using DAX in Power BI
Perform sophisticated calculations such as Time Intelligence, Relationship and Table functions
Audit your formulas by understanding Filter and Row context
Aspiring data professionals looking to master the #1 BI tool on the market.
Excel users who want to learn how to create Professional reports in Power BI.
Data Analytics or BI professionals looking to build expert-level DAX + Power BI skills.
Students looking for a comprehensive, engaging and highly interactive approach to training.
Some basic knowledge in Power BI is strongly encouraged.
Recommend completing my “Microsoft Power BI Bootcamp” course available on Simpliv platform (25-hour virtual course) before registering for this one.
What is DAX?
DAX data types
Calculated Columns
Measures
Aggregation functions
Counting values
Conditional functions
Handling errors
Relational functions
IF function
SWITCH function
Introduction to evaluation contexts
Filter context
Row context
Filtering a table
Using RELATED in a row context
Filters and Relationships
Introduction to CALCULATE function CSV files
CALCULATE syntax explanation
CALCULATE examples
CALCULATE operators
KEEPFILTERS
REMOVEFILTERS
Introduction to Table functions
Filtering a table
Ignoring filters
Mixing filters
DISTINCT
ALLSELECTED
ALLEXCEPT
Introduction to relationship functions
RELATED
RELATEDTABLE
USERELATIONSHIP
CROSSFILTER
TREATAS
Introduction to time intelligence functions
Creating Date table
CALENDARAUTO, CALENDAR
Aggregations over time - YTD, QTD, MTD
DATESBETWEEN
DATESINPERIOD
DATEDIFF
DATEADD
SAMEPERIODLASTYEAR
PREVIOUSMONTH
PARALLELPERIOD
Mixing time intelligence functions
Semi-additive measures
Calculations over weeks