DAX Calculations in Power BI – Beginners to Intermediate
About the Course:
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!
Course Objective:
- 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
Who is the Target Audience?
- 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
Basic Knowledge:
- Some basic knowledge in Power BI is strongly encouraged
- Recommend completing my “Microsoft Power BI Bootcamp” course available on Virtual Trainings platform (25-hour virtual course) before registering for this one
Introduction to DAX
- What is DAX?
- DAX data types
- Calculated Columns
- Measures
- Aggregation functions
- Counting values
- Conditional functions
- Handling errors
- Relational functions
- IF function
- SWITCH function
EVALUATION CONTEXTS
- Introduction to evaluation contexts
- Filter context
- Row context
- Filtering a table
- Using RELATED in a row context
- Filters and Relationships
CALCULATE function
- Introduction to CALCULATE function CSV files
- CALCULATE syntax explanation
- CALCULATE examples
- CALCULATE operators
- KEEPFILTERS
- REMOVEFILTERS
TABLE functions
- Introduction to Table functions
- Filtering a table
- Ignoring filters
- Mixing filters
- DISTINCT
- ALLSELECTED
- ALLEXCEPT
RELATIONSHIP functions
- Introduction to relationship functions
- RELATED
- RELATEDTABLE
- USERELATIONSHIP
- CROSSFILTER
- TREATAS
TIME INTELLIGENCE functions
- 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